Macro for Solver
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
.
|