Deleting Graphs from a Worksheet

[scottscott]

Hello,

How would I delete all the graphs from a particular sheet without knowing the names of the graphs?

Thanks,

ScottScott

 

[SkipVought]

hi,

dim co as chartobject
'delete all chartobjects in active sheet
for each co in activesheet.chartobjects
  co.delete
next

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[scottscott]

Thanks skip did exactly what I needed.