Macro Sheets Only
Equivalent to choosing the Solver command from the Tools menu and choosing the Change button in the Solver Parameters dialog box. Changes the right side of an existing constraint.
If this function is not available, you must install the Solver add-in macro.
Syntax
SOLVER.CHANGE(cell_ref, relation, formula)
For an explanation of the arguments and constraints, see SOLVER.ADD.
Remarks
Related Functions
SOLVER.DELETE Deletes an existing constraint
SOLVER.ADD Adds a constraint to the current problem
List of Command-Equivalent Functions