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 to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

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,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top