Resets all cell selections and constraints in the Solver Parameters dialog box and restores all the settings in the Solver Options dialog box to their defaults. Equivalent to clicking Reset All in the Solver Parameters dialog box. The SolverReset function is called automatically when you call the SolverLoad function, if the Merge argument is False or omitted.

Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select the Solver.xlam check box under Available References. If Solver.xlam does not appear under Available References, click Browse and open Solver.xlam in the \office14\library\Solver subfolder.




This example resets the Solver settings to their defaults before defining a new problem.

Worksheets ("Sheet1"). Activate


SolverOptions Precision:=0.001

SolverOK SetCell:=Range ("TotalProfit"), _

    MaxMinVal:=1, _

    ByChange:=Range ("C4:E6")

SolverAdd CellRef:=Range ("F4:F6"), _

    Relation:=1, _


SolverAdd CellRef:=Range ("C4:E6"), _

    Relation:=3, _


SolverAdd CellRef:=Range ("C4:E6"), _


SolverSolve UserFinish:=False

SolverSave SaveArea:=Range ("A33")