Thread: Deleting charts on a sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Flystar[_9_] Flystar[_9_] is offline
external usenet poster
  
Posts: 1
Default Deleting charts on a sheet
Try this:

Dim i As Integer

For i = 1 To ActiveSheet.ChartObjects.Count
ActiveSheet.ChartObjects(i).Delete
Next

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote