Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Charts > VBA Code > Deleting< Previous | Next > 

 

Delete all the ChartObjects from a worksheet

 
 
1
ActiveSheet.ChartObjects.Delete
   

 

Delete all the chart sheets in a workbook

 
 
2
3
4
Application.DisplayAlerts = False
ActiveWorkbook.Charts.Delete
Application.DisplayAlerts = True
   

 

This deletes the chart sheet called Chart 2

 
 
5
ActiveWorkbook.Charts("Chart 2").Delete
   



 © Better Solutions Limited 10-May-2013< Previous | Top | Next >