View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Damon Longworth Damon Longworth is offline
external usenet poster
 
Posts: 111
Default how to delete a chart using code?

I do not know your process, but you could name all charts that will be
deleted with a similar prefix. Something similar to:

DelChart1

Then you could delete all charts that begin with "Del".

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"pwermuth" wrote in
message ...

Thank you for your help.

The reason I did not name charts is that I am creating 50-100 at a time
and then I do not touch them again in the same Macro. The Macro that is
supposed to deleted them is a cleaning Macro so I do not see a way to
pass the names of the charts to that Macro.


--
pwermuth
------------------------------------------------------------------------
pwermuth's Profile:
http://www.excelforum.com/member.php...o&userid=24997
View this thread: http://www.excelforum.com/showthread...hreadid=386319