Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How turning off screenunpdating with the solver???
I made a macro which runs solver several thousand
times and records the results of each run. The problem is that even after I have set Application.Screenupdating= false, Solver automatically updates the screen at the end when it fills in the best solution values. This slows down the simulations badly. Can anyone tell me how to override the automatic screenupdating after which takes place at the end of a solver run ( I have already set solver not to prompt me to keep or reset the solutions when it finishes a run). Thanks Dominic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turning =E13 to =$E$13 | Excel Worksheet Functions | |||
keeps turning off | Excel Worksheet Functions | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Turning #N/A to a zero...?? | Excel Discussion (Misc queries) | |||
Turning off all screen updates during a Solver routine | Excel Programming |