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
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