stop VBA in solver when maximum iterations reached
in [Programming]
|
From: LOZ on 18 May 2010 22:51 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.
From: ozgrid.com on 18 May 2010 23:48 If lCount=50 Then Exit Sub. -- Regards Dave Hawley www.ozgrid.com "LOZ" <LOZ(a)discussions.microsoft.com> wrote in message news:C471F1A5-9419-4737-AEF0-2CFB7C1662E8(a)microsoft.com... > 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. >
|
Pages: 1 Prev: Change Pivot Table Page Value Next: loop through all worksheets |