I’m running solver in a loop and since I’m checking a number of possible solutions I’ve set max time to 6 seconds.
This speeds up the time it takes for solver to find a solution but if no solution is found after 6 second the “Show Trial Solution” window with its message “The maximum time limit was reached; continue anyway?” pops up.
By clicking the “Stop” button Solver starts on the next loop so depending on the staring point it usually takes 2 – 3 “clicks” before a solution is found.
Running the macro and keeping the “Alt” and the “S” button pressed will keep Solver running without stopping even if the “Show Trial Solution” window pops up for a second so I’ve tried to add the line
to my macro but I’ve not been able to make it work. Any hints on how to solve this?
Alf
Bookmarks