PDA

View Full Version : Copying a range from a different workbook



gmcconville
07-06-2011, 03:04 AM
Hello

Is there anyway to copy a range from one workbook to another using the = method

eg: Workbooks(1).Worksheets(1).Range("A1:A10") = Workbooks(2).Worksheets(1).Range("A1:A10")

I have tried this and it does not seem to copy anything, and no error comes up.

I can successfully do it by

Workbooks(2).Worksheets(1).Range("A1:A10").Copy Workbooks(1).Worksheets(1).Range("A1:A10")

But I am looking at different methods and the difference in speed that each method takes.

Thanks

CatDaddy
07-06-2011, 09:49 AM
fastest!!!

Workbooks("Destination").Worksheets(1).Range("A1:A10").Value = Workbooks("Source").Worksheets(1).Range("A1:A10").Value