Copy paste from one worbook to another workbook

I think you need to specify the worksheet before the range on the first select:

Please Login or Register  to view this content.

Also when copying and pasting there is no need to activate or select anything. Look at the Copy Method example in VBA help.

Please Login or Register  to view this content.

I'm trying to do something similar;
If I understand correctly, this bit of code is copying a range from the active workbook into a second (open but inactive) workbook. How then would I re-arrange the code to go the other way; copy something from an open but inactive workbook into the active workbook?

Please Login or Register  to view this content.

That earlier piece of code was incorrect, it should have been:

Please Login or Register  to view this content.

Originally Posted by sbrandt

How then would I re-arrange the code to go the other way; copy something from an open but inactive workbook into the active workbook?

I would do it like this:

Please Login or Register  to view this content.

thanks very much last piece of code works as i wanted