counting charts

[dstiefe]

I am trying to write the code that counts the charts (embedded charts) on a
worksheet.

thank you

 

[optionbase1]

use the

for n = 1 to worksheets.count
numberOfCharts = numberOfCharts + worksheets(n).charts.count
next n


(check my syntax ...)

 

[Jon Peltier]

Worksheets("Sheet1").ChartObjects.Count

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[dstiefe]

Thank you!!

Worksheets("Sheet1").ChartObjects.Count

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[dstiefe]

Thank you!!