ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How turning off screenunpdating with the solver??? (https://www.excelbanter.com/excel-programming/276371-how-turning-off-screenunpdating-solver.html)

Dominic Tremblay

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


All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com