Equivalent to choosing Range Analyze Solver... and pressing the Change button in the Solver Parameters dialog box. Changes the right hand side of an existing constraint.

Syntax

SolverChange(CellRef, Relation, FormulaText)

For an explanation of the arguments and constraints, see SolverAdd.

Remarks

If the combination of CellRef and Relation does not match any existing constraint, the function returns the value 4 and no action is taken.

To change the CellRef or Relation of an existing constraint, use SolverDelete to delete the old constraint and then use SolverAdd to add the constraint in the form you want.