Solver marco still prompts to keep solution

  • Thread starter Thread starter Greg Snidow
  • Start date Start date
G

Greg Snidow

Greetings. I was able to record a macro for solver, and it works like a
charm. However, even though I did not stop recording until after I chose
"keep solver solution", and then hit ok, the dialog box asking me if I want
to keep the solution still pops up. Any ideas on how to get it to
automaticall keep the solution if one is found? Below is the macro.

Thank you

Greg

SolverReset
SolverOk SetCell:="$N$7", MaxMinVal:=2, ValueOf:="0",
ByChange:="$B$8:$M$8"
SolverAdd CellRef:="$N$3:$N$7", Relation:=1, FormulaText:="$P$3:$P$7"
SolverAdd CellRef:="$N$8", Relation:=2, FormulaText:="$P$8"
SolverOk SetCell:="$N$7", MaxMinVal:=2, ValueOf:="0",
ByChange:="$B$8:$M$8"
SolverOptions MaxTime:=100, Iterations:=100, Precision:=0.000001,
AssumeLinear _
:=True, StepThru:=False, Estimates:=1, Derivatives:=1,
SearchOption:=1, _
IntTolerance:=5, Scaling:=False, Convergence:=0.0001,
AssumeNonNeg:=True
SolverOk SetCell:="$N$7", MaxMinVal:=2, ValueOf:="0",
ByChange:="$B$8:$M$8"
SolverSolve
 
Back
Top