![]() |
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. |
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