Forum Discussion
Question: Display number of series on a chart in an excel cell
I have a excel chart which may contain 0-255 series. Since the chart legend can't hold all the names, I would like a formula that would just put the total number of series in the object in an excel ...
Your UDF is a non-volatile type try to recalculate it
ActiveSheet.Calculate
or
Range.Calculate
More info about realculations can be found below:
https://docs.microsoft.com/en-us/office/client-developer/excel/excel-recalculation