<div>
To delete the chart try this: 
 
ActiveSheet.ChartObjects(i).Delete
</div>

To delete the chart try this:

ActiveSheet.ChartObjects(i).Delete

<div>
<div class="content wysiwyg-content">
I'm trying to copy all charts on a worksheet as pictures, and then delete all of the original charts. &nbsp;What I have for code right now is: 
 
Sub ConvertCharttoPicture() 
 
Dim i As Integer 
Dim intX As Integer 
 
For i = 1 To ActiveSheet.ChartObjects.Count 
&nbsp; &nbsp; &nbsp; &nbsp; ActiveSheet.ChartObjects(i).Activate 
&nbsp; &nbsp; &nbsp; &nbsp; ActiveSheet.ChartObjects(i).Select 
&nbsp; &nbsp; &nbsp; &nbsp; ActiveChart.ChartArea.Select 
&nbsp; &nbsp; &nbsp; &nbsp; ActiveChart.CopyPicture _ 
&nbsp; &nbsp; &nbsp; &nbsp; Appearance:=xlPrinter, Size:=xlScreen, Format:= _ 
&nbsp; &nbsp; &nbsp; &nbsp; xlPicture 
&nbsp; &nbsp; &nbsp; &nbsp; ActiveChart.Paste 
 
Next 
 
End Sub 
 
One problem is that I cannot figure out how to delete the original chart. &nbsp;The second problem is that this loops indefinitely, going over the same chart, again and again. &nbsp;Any assistance at making this work would be great! &nbsp;I intend to use this on many, many worksheets as part of another macro. 
 
Thank you!
</div>
</div>

I'm trying to copy all charts on a worksheet as pictures, and then delete all of the original charts.  What I have for code right now is:

Sub ConvertCharttoPicture()

Dim i As Integer
Dim intX As Integer

For i = 1 To ActiveSheet.ChartObjects.Count
        ActiveSheet.ChartObjects(i).Activate
        ActiveSheet.ChartObjects(i).Select
        ActiveChart.ChartArea.Select
        ActiveChart.CopyPicture _
        Appearance:=xlPrinter, Size:=xlScreen, Format:= _
        xlPicture
        ActiveChart.Paste

Next

End Sub

One problem is that I cannot figure out how to delete the original chart.  The second problem is that this loops indefinitely, going over the same chart, again and again.  Any assistance at making this work would be great!  I intend to use this on many, many worksheets as part of another macro. 

Thank you!

Replace all charts with pictures on a worksheet?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.