Try

Dim CH As Chart
Application.DisplayAlerts = False
For Each CH In ThisWorkbook.Charts
CH.Delete
Next CH
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"BrownTing"
wrote in
message
...

Hi Everyone,

Essentially I have made a program that produces charts as a new
worksheet (Chartsheet); however I have some code that works on
the
number of worksheets produced and will mess up when more charts
are
added. I cannot modify the code nor produce charts inside of a
worksheet but this will cause more problems.

My question:

Does anyone know a command in Visual Basic that deletes charts
produced
as worksheets (chartsheet)?

-Identify a charts produced as a worksheets (tab)
-delete charts (without a specific tab name) (Ex. Chart 1,
Chart
2...ect)
-delete all charts without referring to their name.

Thanks


--
BrownTing
------------------------------------------------------------------------
BrownTing's Profile:
http://www.excelforum.com/member.php...o&userid=34919
View this thread:
http://www.excelforum.com/showthread...hreadid=560678