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