| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation (error 1004)
I need a surefire way to setup a macro to be re-run (a thousand times even).
I have tried to delcare ap, workbook, and worksheet as variables and then insert xlsheet before all necessary lines; however, it never works right. Then I get other errors and I end up rewriting about a 1/3 of my code. What are some really good ways for setting up a macro for automation that you have discovered? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error 1004, Application-definded or object-defined error | Excel Programming | |||
| run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
| Unknown where is the problem on the Runtime error - Automation error | Excel Programming | |||
Threaded Mode
