The clipboard is a shared resource and one macro using or clearing it could
interfere with the other. You might consider setting a flag of some sort
when a macro starts its copy and clearing it when done. The macro would
also have to check if the flag is already set before it does its copy. A
flag could be a text file or an INI file entry or registry entry.

--
Jim
"DaveM" wrote in message
...
| 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