Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to check if sheet has graphs?
Hi there,
I like to check if sheet has any graph. And if it does copy the graph to new sheet (add sheet "Graphs" if none found). In this case there will be only one graph in one sheet. Thanks in advance. Musa |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to check if sheet has graphs?
This code tells how many charts on a specified sheet:
Worksheets("Sheet2").ChartObjects.Count best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "musa.biralo" wrote in message ... Hi there, I like to check if sheet has any graph. And if it does copy the graph to new sheet (add sheet "Graphs" if none found). In this case there will be only one graph in one sheet. Thanks in advance. Musa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
4 graphs / one sheet / cramming for space | Charts and Charting in Excel | |||
how can i put graphs on one sheet | Charts and Charting in Excel | |||
how can i put graphs on one sheet | Charts and Charting in Excel | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Graphs and sheet referencing? | Excel Worksheet Functions |