I am trying to write the code that counts the charts (embedded charts) on a worksheet. thank you
D dstiefe Aug 1, 2005 #1 I am trying to write the code that counts the charts (embedded charts) on a worksheet. thank you
O optionbase1 Aug 2, 2005 #2 use the for n = 1 to worksheets.count numberOfCharts = numberOfCharts + worksheets(n).charts.count next n (check my syntax ...)
use the for n = 1 to worksheets.count numberOfCharts = numberOfCharts + worksheets(n).charts.count next n (check my syntax ...)
J Jon Peltier Aug 2, 2005 #3 Worksheets("Sheet1").ChartObjects.Count - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______
Worksheets("Sheet1").ChartObjects.Count - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______
D dstiefe Aug 2, 2005 #4 Thank you!! Jon Peltier said: Worksheets("Sheet1").ChartObjects.Count - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Click to expand...
Thank you!! Jon Peltier said: Worksheets("Sheet1").ChartObjects.Count - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Click to expand...
