Delete ALL Charts in a WorkSheet (VB)

Corey · Oct 4, 2006

How can i Delete ALL charts on a worksheet by code?

I tried recording a macro but it will only delete the numbered chart.
I need an ALL chart delete code.

any ideas

Corey....

Andy Pope · Oct 4, 2006

Hi,

Use with case

activesheet.chartobjects.delete

Cheers
Andy

Corey · Oct 4, 2006

thanks
done the job

Andy Pope said:
Hi,

Use with case

activesheet.chartobjects.delete

Cheers
Andy