object doesnt support this property or method

I have simple code to switch between two workbooks, and I get a an "error 438 object doesnt support this property or method" near the end. What am I going wrong?

Please Login or Register  to view this content.

You have to do something with the range

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Or you could place it on your copy line

Please Login or Register  to view this content.

Okay I selected and pasted in the selection, and get the same error there

Please Login or Register  to view this content.

it seems that I cannot use the paste method in the other workbook

solved: have to use Activesheet.Paste instead of Selection.Paste

Please Login or Register  to view this content.

SOURCE:
http://www.mrexcel.com/forum/excel-q...ty-method.html