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
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