VBA Delete Graph

Analyze_This

Board Regular
Joined
Oct 29, 2008
Messages
122
I have a chart that I need to get rid of as part of my code. I recorded this part of the macro and ended up with the following code

Code:
ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Graph-State-KU"
ActiveChart.CopyPicture
ActiveChart.Parent.Delete
ActiveChart.Pictures.Paste.Select

ActiveChart.Parent.Delete is where I get the error

Simple, right? It's what the macro recorder gave me, it's what everyone posts on the web when deleting a graph. But it always gives me the same error: "Object doesn't support this property or method"

The chart is in a sheet by itself, so I can't use activechart.delete because that deletes the entire sheet, not just the chart. Any ideas?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
The chart is in a sheet by itself, so I can't use activechart.delete because that deletes the entire sheet, not just the chart.
... and why do you want to delete a chart from a chart sheet and NOT the chart sheet?
 

Watch MrExcel Video

Forum statistics

Threads
1,112,817
Messages
5,542,666
Members
410,567
Latest member
SCraig123
Top