ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   can't move chart to new worksheet (https://www.excelbanter.com/charts-charting-excel/204015-cant-move-chart-new-worksheet.html)

tom

can't move chart to new worksheet
 
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.


All times are GMT +1. The time now is 01:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com