Run-Time Error 1004 Method Range of object _Global Failed?

Hi There,

hope your well, Im new to Macro's and im getting a little confused,

I and trying to copy data from active sheet as I have over 60 sheets...1sheet.named (Orig1.xls) (in say E7) to the last/Next Availabe row in another spreadsheet.ie Test2.xls using excell 2000. I have attached my code if it helps, can anyone guide me or point me to my error would be greatly appreciated. Thanks for reading.

Please Login or Register  to view this content.

Thanks Again

hi MadDino,
Welcome to the forum
if you have usedrange in200xl

Please Login or Register  to view this content.