View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DaveM DaveM is offline
external usenet poster
 
Posts: 31
Default PasteSpecial Error 1004?

Hi;
I have two seperate workbooks open and each running a macro that do
different types of copy and pastespecial routines. By themselevs (eg. when
only one file is open and running) the macro runs fine. Each macro prefroms
a copy and pastespecial routine at different intervals. One runs every 60
secs and the other runs every 15 secs.

When i run both marcos with the files open and i step away i (not
interacting with either file, etc.) I get a error routinely that reads
"pastespecial of Range Class Failed Error 1004".

Without dumping the code in here do you have any ideas what this could be
caused by? The two macros confliciting somehow with clipboard, or thier
timing is being conflicted?

Thanks
DaveM