Equivalent to choosing Range Analyze Solver..., pressing the Variables button, and then pressing the Change button in the Solver Parameters dialog box. Changes a set of decision variable cells.

Syntax

SolverChange(CellRef, 0, NewRef)

CellRef is a reference to a cell or a range of cells on the active worksheet, currently defined in the By Changing Variable Cells list box as variable cells.

NewRef is a reference to a different cell or range of cells on the active worksheet, which will replace CellRef as a new set of variable cells.

Remarks

If CellRef does not match any existing set of variable cells, the function returns the value 1 and no action is taken.