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")

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Velero" wrote in message
...
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

Yes. This was, exactly

Thank you very much!!!!!!

Velero

-----Original Message-----
Is this what you are looking for?

SolverReset

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

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Velero" wrote in message
...
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


.