ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   stop VBA in solver when maximum iterations reached (https://www.excelbanter.com/excel-programming/442650-stop-vba-solver-when-maximum-iterations-reached.html)

Loz

stop VBA in solver when maximum iterations reached
 
hi
I would like to add to the VBA code in a way that stops running Solver
after the max iterations has been reached. I would like to do so in a way
that there is no dialogue box for the user.

i.e. I want NO user interaction whatsoever as the solver code is part of a
loop and I want it to move on to the next iteration even if the maximum
iteration was reached.


ozgrid.com

stop VBA in solver when maximum iterations reached
 
If lCount=50 Then Exit Sub.



--
Regards
Dave Hawley
www.ozgrid.com
"LOZ" wrote in message
...
hi
I would like to add to the VBA code in a way that stops running Solver
after the max iterations has been reached. I would like to do so in a way
that there is no dialogue box for the user.

i.e. I want NO user interaction whatsoever as the solver code is part of a
loop and I want it to move on to the next iteration even if the maximum
iteration was reached.




All times are GMT +1. The time now is 07:18 PM.

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