ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   deleting a chart using a macro (https://www.excelbanter.com/excel-programming/379035-re-deleting-chart-using-macro.html)

Tom Ogilvy

deleting a chart using a macro
 
Assuming an embedded chart:

Activesheet.ChartObjects(1).Delete


--
Regards,
Tom Ogilvy



"stargategirl" wrote in message
...
how can i delete a chart within a macro but still be able to view the
chart
before it deletes itself? and if i create the chart each time using
another
macro, how can i create a macro that deletes that chart? HELP!





All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com