counting charts
 

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

thank you

use the

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


(check my syntax ...)


--
optionbase1
------------------------------------------------------------------------
optionbase1's Profile: http://www.excelforum.com/member.php...o&userid=25212
View this thread: http://www.excelforum.com/showthread...hreadid=391999

Worksheets("Sheet1").ChartObjects.Count

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


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

thank you

Thank you!!

"Jon Peltier" wrote:

Worksheets("Sheet1").ChartObjects.Count

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


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

thank you

Thank you!!

"optionbase1" wrote:


use the

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


(check my syntax ...)


--
optionbase1
------------------------------------------------------------------------
optionbase1's Profile: http://www.excelforum.com/member.php...o&userid=25212
View this thread: http://www.excelforum.com/showthread...hreadid=391999