Copying a range from a different workbook

[gmcconville]

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]

fastest!!!
[VBA]
Workbooks("Destination").Worksheets(1).Range("A1:A10").Value = Workbooks("Source").Worksheets(1).Range("A1:A10").Value
[/VBA]