Recent content by owen_2006

Hi gemma-the-husky, Thanks for the suggestion, which thread was doing a similar discussion....I can't seem to find it. Thanks, O

Hi Again Robert88, Actually the error that comes up is "Paste method of range class failed" so I think that the past command needs to be changed, but I'm not sure. Any advice is gratefully appreciated. Thanks again Owen

Hi Robert88, Thanks for replying, Yes I have a sheet in the Temp.xls file called ALLFRSMPG and the top left cell is A1. Do I need to rename this cell and specify the new name range? Looking forward to your reply, Kind regards Owen

Hi Guys, I have a problem that i have been trying to fix for a while now without much success. I have been trying to do a simple copy and paste from one spreadsheet to another and i keep getting a "Paste method of range class failed" error whenever i test the macro. Can I please trouble anyone...