Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PasteSpecial Method Error | Excel Discussion (Misc queries) | |||
Runtime Error 1004 when trying to PasteSpecial | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |