SolverChange Function Example

This example loads the previously calculated Solver model stored on Sheet1, changes one of the constraints, and then solves the model again.

Worksheets("Sheet1").Activate
SolverLoad loadArea:=Range("A33:A38")
SolverChange cellRef:=Range("F4:F6"), _
    relation:=1, _
    formulaText:=200
SolverSolve userFinish:=False