if chart exists, remove it

[shew0387]

I'm trying to update charts by hitting a button I've made in the wkst, so if there is new data, it will remove the old chart, and replace it with a new chart of the same name - all the charting works properly, but the following code only removes the chart if it already present...but doesn't work if there isn't a chart there already -- If there is no chart by that name, I'd like to skip the code and continue with the rest of my code that creates the chart...

ActiveSheet.ChartObjects("Crack_location_length").Activate
ActiveChart.ChartArea.Select
ActiveWindow.Visible = False
Selection.Delete
Range("N6").Select

 

[Zack Barresse]

Hi,


MS MVP Tushar Mehta's web site ( http://www.tushar-mehta.com/ ) will give you some great examples where you don't have to do that, but rather just make your charts dynamic.

HTH