Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted Calculation
Excel 2003. I am using a VBA procedure to step through a worksheet
from bottom to top with a for-to loop, looking at the cell in column A for each row. If column A contains different text than the previous cell in column A, I insert a row about that one with text to indicate what the numbers in each cell refer to. To speed up the process, I use Application.Calculation=xlManual before starting the loop. As the loop runs, Excel flashes "Ready" and "Calculate" in the statusbar. Since the statusbar says "Calculate", I presume it really is recalculating the sheet each time it inserts a row, thereby slowing down my procedure. Is Excel really calculating like I think it is? And, if so, how can I prevent this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unwanted add-in | Setting up and Configuration of Excel | |||
Unwanted Rounding | Excel Discussion (Misc queries) | |||
Unwanted Cells | Excel Discussion (Misc queries) | |||
unwanted zeros | Excel Programming | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming |