SOLVER.CHANGE

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

• If the combination of cell_ref and relation does not match any existing constraint, the function returns the value 4 and no action is taken.
• To change the cell_ref or relation of an existing constraint, use SOLVER.DELETE to delete the old constraint and then use SOLVER.ADD to add the constraint in the form you want.

Related Functions

SOLVER.DELETE Deletes an existing constraint

SOLVER.ADD Adds a constraint to the current problem

List of Command-Equivalent Functions