Have you changed Excel versions as well. Have you gone from xl97 or xl2K to
xl2002 or xl2003?

Are the worksheets you are pasting to protected?

do you have any problem performing the paste operation manually.

--
Regards,
Tom Ogilvy


"keys4worship" wrote in message
ups.com...
My company recently upgraded to xp pro from 2k. Every macro involving a
copy paste is failing with a 1004 error during the paste method. We
have 1 machine that has not been upgraded. The macros still work on
this machine. Our head office will not allow us to keep the one machine
on 2k. We are talking about 100's
if not 1000's of man hours lost if a solution cannot be found.

Thanks for any help