Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turning =E13 to =$E$13 Bishop Excel Worksheet Functions 3 February 4th 10 06:58 PM
keeps turning off rio Excel Worksheet Functions 4 August 31st 07 02:08 AM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Turning #N/A to a zero...?? bigtim Excel Discussion (Misc queries) 5 July 26th 05 08:48 PM
Turning off all screen updates during a Solver routine Tony Scullion Excel Programming 3 August 15th 03 08:09 PM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"