Copy/Paste charts

R

Rui

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
 

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

macro problem 2
Reposition Chart Macro 6
Copy/Paste charts 1
Chart Title color can't be duplicated (also series color) 0
Print problems w/ charts excel 2003/2007 3
Problem with excel macro - getting automation error - URGENT 1
Manipulate GIF that has been inserted using Paste Special 1
How to copy multiple objects from Excel to PowerPoint 0

Top