can't move chart to new worksheet

T

Tom

I am creating a an embedded chart and then move it to another worksheet that
would contain all my charts.

After I create the chart I want to move it to another sheet. here is my code:

ActiveSheet.ChartObjects("chart1").Activate
ActiveChart.ChartArea.Select
ActiveWindow.Visible = False
ActiveWindow.WindowState = xlNormal
ActiveWindow.WindowState = xlMaximized
Sheets("charts").Select
Range("A1").Select
ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)",
Link:=False _
, DisplayAsIcon:=False

It gives me an error indicating that it can't find the charts object
property of the worksheet class.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Chart and PasteSpecial 2
Cannot change Series references 4
Cannot change title of second chart 2
Reposition Chart Macro 6
Chart macro 4
Print problems w/ charts excel 2003/2007 3
Copy/Paste charts 1
help on vba macro to put multiple charts on multiple worksheets based on table in each worksheet 0

Top