counting charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ...)
 
Worksheets("Sheet1").ChartObjects.Count

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying embedded charts 1
Chart SERIES OFFSET 3
How to create a bubble chart with more than 2 variables 0
how to copy sheet with charts without link to original data 6
Dynamic Chart Formula Question 5
Chart Location Impact On Links When Copying To New Workbook 1
Odd Chart Format Results 1
Print Specific Charts 5

Back
Top