Paste Chart

[Richard1963]

Hi,

I am attempting to speed up some code and am removing all the .select's, hopefully replacing them all with, with. I am attempting to copy a selction of charts from one workbook to another using the following

With Workbooks(nmefile).Worksheets("EEX Graphs")
.DrawingObjects.Copy
End With

With Workbooks(wrkDR).Worksheets("EEX Graphs").range("B2")
.Pictures.Paste.Select
End With

This unfortunatgely fails at the line .pictures.paste.select
Is there any way to acheive a copy of a chart or charts from one workbook to another without having to constantly switch between workbooks and worksheets. I am using excel 2007

Thanks in advance

 

[Richard1963]

sorry I was being a dubmarse, i have figured it now, apologies for waisting anyone's time.