Solver macro

[MetLife]

Hi,

I am reviewing a macro. There is logic that appears to use the solver, but I wasn't sure.

SolverReset
SolverOk SetCell:="$E$7", MaxMinVal:=3, ValueOf:="0", ByChange:="$D$16"
SolverOptions AssumeNonNeg:=False
SolverAdd CellRef:="$D$16", Relation:=1, FormulaText:="0.05"
SolverAdd CellRef:="$D$16", Relation:=3, FormulaText:="-0.05"
SolverSolve True
Worksheets("discount_shift").Activate

Does anyone know what "SolverReset" does? I wasn't sure if this was a function or just part of the solve routine. Thanks

 

[Eric W]

SolverReset clears out any existing parameters that were previously given to Solver.