Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a macro that seems to be running slowly when left to its own devices. I did some testing to figure out which particular part of the macro was being slow (a part that loops through an array and writes data to a worksheet). If I put a breakpoint immediately before the slow part then hit F5 to continue execution, it runs much faster (2 secs versus 30 secs without the breakpoint). This makes no sense to me. Can someone please explain what precisely is happening here? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range Name affecting speed of macro | Excel Worksheet Functions | |||
Range Name affecting speed of macro | Excel Programming | |||
Macro affecting hyperion retreive | Excel Programming | |||
Breakpoint ok, no breakpoint messes up... | Excel Programming | |||
sumproduct, arrays affecting speed | Excel Worksheet Functions |