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:
Dim i As Integer
Dim intX As Integer
For i = 1 To ActiveSheet.ChartObjects.Count
Appearance:=xlPrinter, Size:=xlScreen, Format:= _
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.