Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code execution speed question
i have code that opens about 12 workbooks and scans for a value in a cell
and then copies that line to the report sheet. all of the usual settings set to false and my code runs fine, finishes in about 7 or 8 seconds. but have a question. if i have the vb window open, click the run button to run the code, it slows down and i can see all of the code windows for each workbook open. report takes about 14 or 15 seconds and i can see it scroll through the 56 lines in each sheet in the immediate window. they scroll really fast. but if i click the control toolbox button on the report sheet itself, the report takes about a minute to run and i can see the row numbers as they scroll by very slowly. what's the difference between hitting the run code button in vb and clicking on the button on the sheet? sure is a big difference in code execution time. -- Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted code execution | Excel Discussion (Misc queries) | |||
Execution speed for UDF | Excel Programming | |||
Extremely Slow VBA Execution Speed | Excel Programming | |||
MACRO execution speed | Excel Programming | |||
VBA: Pausing Code Execution | Excel Programming |