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.

Leave a Reply