T
Tom
I am trying to modify a bunch of charts using a For each loop. However when I
check to count the number of charts I get 0. Here is my code:
MsgBox ActiveWorkbook.Charts.Count (this message show 0 charts)
' however this following message indicates the workbook contains a chart
named Chart 85
MsgBox ActiveWorkbook.Charts.Name (this message show "Chart 85")
So since there are 0 charts the for loop does not work
For Each mychart In ActiveWorkbook.Charts
check to count the number of charts I get 0. Here is my code:
MsgBox ActiveWorkbook.Charts.Count (this message show 0 charts)
' however this following message indicates the workbook contains a chart
named Chart 85
MsgBox ActiveWorkbook.Charts.Name (this message show "Chart 85")
So since there are 0 charts the for loop does not work
For Each mychart In ActiveWorkbook.Charts