Copy from one sheet to another

So my program copies a spreadsheet over to my main one then is suppose to search the new sheet for certain information then copy and paste it to the original sheet. However I keep getting the Application defined error and it doesnt seem to matter how I want to copy the range or select the range it does not work and I get the error. Any help would be greatly appreciated.

Please Login or Register  to view this content.

FYI as soon as I change the range to just a cell it works just fine so I am not sure why the range is not working

Hi, xPhenom,

make sure to fully qualify the path to both Range and Cells used within that range.

FYI: Row is a VBA Keyword, you should use a different name for the variable.

Ciao,
Holger