Equivalent to choosing Range Analyze Solver..., pressing the Variables button, and then pressing the Delete button in the Solver Parameters dialog box. Deletes an existing set of variable cells.

Syntax

SolverDelete(CellRef, 0, 0)

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.

Remarks

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