Identifying chart object sheets in Excel VBA 1

[Duffymk]

Hello -

I am trying to write some code which moves through sheets and colours certain cells on each sheet. However, if the workbook contains a sheet which is only a graph, an error occurs. I would like a way to identify a sheet as being a chart object, so that then I can skip over it. Is there a way to do this?

Essentially I want to say:

If sheet is chart then
move to next sheet
else
run the code

Thanks!
Molly

 

[TonyJollans]

Hi Molly,

Use the Worksheets collection, which doesn't contain the Chart sheets in the first place.

Instead of using

[purple]For Each objSheet In ActiveWorkbook.Sheets[/purple]

try, instead,

[blue]For Each objSheet In ActiveWorkbook.Worksheets[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[Duffymk]

Thank you - that worked perfectly!

MD