ExcelBanter - deleting a chart object

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - deleting a chart object (https://www.excelbanter.com/excel-programming/293050-deleting-chart-object.html)

alldreams

deleting a chart object

how could I have a macro delete a chart object from a
sheet? keep in mind the chart object name changes.

Thanks for your help

Tom Ogilvy

deleting a chart object

activeSheet.ChartObjects(1).Delete

--
Regards,
Tom Ogilvy

"alldreams" wrote in message
...
how could I have a macro delete a chart object from a
sheet? keep in mind the chart object name changes.

Thanks for your help

All times are GMT +1. The time now is 10:02 AM.