| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
counting charts
I am trying to write the code that counts the charts (embedded charts) on a
worksheet. thank you |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charts won't update | Charts and Charting in Excel | |||
| Give multiple charts on a worksheet/workbook same header or footer | Excel Discussion (Misc queries) | |||
| Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
| linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
Linear Mode
