| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move row to another worksheet | Excel Discussion (Misc queries) | |||
| How to draw a line on a chart, and have it move with the chart? | Charts and Charting in Excel | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| How do i move a chart | Charts and Charting in Excel | |||
| How to move location of chart within a worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
