Macro for Solver

  • Thread starter Thread starter Velero
  • Start date Start date
V

Velero

I wrote a macro in VBA for running solver. The problem is
that each time I run it, the Solver window in Excel is
saving the constraints (adding again the arguments in the
constraint window). I think I need to add an argument in
order to Reset all the solver parameters before setting
the target, changing, and
constraint arguments. Any help on that?

Thanks in advance

Velero
 
Is this what you are looking for?

SolverReset

SolverOk _
SetCell:=Range("G14"), _
MaxMinVal:=1, _
ByChange:=Range("G9:I9")
 
Back
Top