Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My piece of code runs under manual calculation mode. When it is done I want
the whole lot to be recalculated. Towards the end of my code I have the following statements: With Application .Calculation = xlAutomatic .MaxChange = 0.001 End With End Sub The problem: Watching the worksheet status in the right bottom corner of the screen I see that the lot is calculated twice (the "Calculating xx%" runs from 0 to 100 twice) which is a bit of a nuisance since it takes quite a while. How can I get it to calculate only once? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
*****PLEASE******* FIX AUTOMATIC CALCULATION | Excel Worksheet Functions | |||
Automatic calculation | Excel Worksheet Functions | |||
Automatic Calculation | Excel Programming | |||
Automatic Calculation | Excel Discussion (Misc queries) | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming |