| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste charts
Hi,
i´m trying to copy a selection of charts from a workbook to another. Here´s my yet-to-be-over lines: Windows("BDs.xls").Activate ActiveSheet.ChartObjects("Chart 11").Activate ActiveSheet.Shapes.Range(Array("Chart 11", "Chart 12", "Chart 13", "Chart 14" _ , "Chart 15", "Chart 16")).Select Selection.Copy Windows(F).Activate ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)", Link:=False _ , DisplayAsIcon:=False As i see it, when i run the macro, it only copies the first chart, and then it bugs when tries to paste. can anyone help me? thanks, Rui |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste charts as object inside excel | Charts and Charting in Excel | |||
| Excel charts copy / paste crops the images | Charts and Charting in Excel | |||
| How to copy & paste excel charts to Words as Windows Metafile | Charts and Charting in Excel | |||
| Copy/Paste charts | Charts and Charting in Excel | |||
| How do I copy and paste Excel charts and retain formatting? Mine . | Charts and Charting in Excel | |||
Threaded Mode
