Delete ALL Charts in a WorkSheet (VB)
 

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

Delete ALL Charts in a WorkSheet (VB)
 

Hi,

Use with case ;)

activesheet.chartobjects.delete

Cheers
Andy

Corey wrote:
/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, Microsoft MVP - Excel
http://www.andypope.info

Delete ALL Charts in a WorkSheet (VB)
 

thanks
done the job

"Andy Pope" wrote in message
...
Hi,

Use with case ;)

activesheet.chartobjects.delete

Cheers
Andy

Corey wrote:
/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, Microsoft MVP - Excel
http://www.andypope.info