Delete Chart If It Exists and Select Non-Contiguous Columns

[always_confused]

Hello, I am trying to write a macro that builds a chart when it is run. However, if the chart already exists (ie if the macro has already been run at least once), I would to delete the existing chart and create a new one. To be honest the whole ChartObject vs Chart thing is not very clear to me, so I can't figure out how to delete my chart.
I'm trying to do something like

On Error Resume Next
'somehow delete the chart
On Error GoTo 0

 

[Zot]

If there is only one chart on the sheet, I think you can just write

ActiveSheet.ChartObjects(1).Delete

 

[always_confused]

If there is only one chart on the sheet, I think you can just write

ActiveSheet.ChartObjects(1).Delete

I have 3 charts. Should I do

ActiveSheet.ChartObjects(1).Delete
ActiveSheet.ChartObjects(2).Delete
ActiveSheet.ChartObjects(3).Delete

?

 

[Zot]

I have 3 charts. Should I do

ActiveSheet.ChartObjects(1).Delete
ActiveSheet.ChartObjects(2).Delete
ActiveSheet.ChartObjects(3).Delete

?

Should be, but you can also loop through all charts like this example

VBA Excel: Deleting all charts and graphs in a workbook, except one

I have a macro that generates a lot of worksheets and charts. There's also various subroutines that run so the names and quantity of each worksheet/chart generated is never the same. What is consta...

stackoverflow.com

 

[always_confused]

Should be, but you can also loop through all charts like this example

VBA Excel: Deleting all charts and graphs in a workbook, except one

I have a macro that generates a lot of worksheets and charts. There's also various subroutines that run so the names and quantity of each worksheet/chart generated is never the same. What is consta...

stackoverflow.com

Works great, thanks for the help