VBA Copy & Paste Stopped Working

Hi guys,

Got a strange one for you.
Last Friday, my department at work used numerous macros to perform daily tasks.
On Tuesday when we came in, they had all stopped working.

The code is basically what I have posted below. It seems that when you open a new workbook, the clipboard is being emptied and therefore the paste is failing with the following error:

"Run-time error '1004': PasteSpecial method of Range class failed"

Has anyone seen this error before? Any M$ updates that may have caused it?
I am using Excel 2003.

Please Login or Register  to view this content.

Cheers,
Adam

I hope the following codes will be helpful

Please Login or Register  to view this content.

Originally Posted by amulee

I hope the following codes will be helpful

Please Login or Register  to view this content.

Hi Amulee,

That code will work and thank you heaps but unfortunately, we have 30+ macros all written by 10+ different people with no instructions and I'm trying to understand what may have caused this issue to only start happening now in the hope i can fix that rather than try and upgrade every single macro.

If Microsoft has released a patch that may have caused this, i'd love to know so I can get the I.T dept to rollback the change.


Cheers,
Adam