I am trying to open a different .xls file and copy an area, then paste the area into the current spreadsheet.
I have:
However, when running this, I get:Code:Workbooks.Open Filename:="Blah Blah Blah" Range("A2:G82").Select Selection.Copy
"Select method of Range class failed"
What am I missing?




Reply With Quote