| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro runs faster when VB code window open
I have a macro that runs quite fast when the Visual Basic code window is
open. But if it is closed takes a few minutes. The macro reads one sheet and writes a in a second one when new data is found for the report, I know is faster to read all data, fill up an array and then write it all at once. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro runs in another workbook if you open simultaneously | Excel Programming | |||
| WHY the same macro runs so slowly on a different but faster comput | Excel Discussion (Misc queries) | |||
| Which runs faster | Excel Programming | |||
| Macro runs upon wkbk open, but no Workbook_Open or Auto_Open Macro | Excel Programming | |||
| macro only runs on fresh open of excel? | Excel Programming | |||
Threaded Mode
