Custom excel function not updating
I was able to solve the issues by encapsulating my dates (the axis labels) in a TEXT formula as such: =TEXT(A10,"MMM-YY").
Count For i = 1 To Sh Count - 1For j = i 1 To Sh Count If Sheets(j).
Here is the code that will unhide all the worksheets in the workbook.
The above code uses a VBA loop (For Each) to go through each worksheets in the workbook.
The solution I found was to update the x-axis for all series and then it refrehsed (also I had code to change the format of the x-axis, but I don't think that that was the problem).
$BQ:$BQ44" Sub TEST() ' ' TEST Makro ' Active Sheet.