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
>
>