Equivalent to choosing Range Analyze Solver..., choosing the Options button from the Solver Parameters dialog box, and choosing the Save Model button in the Solver Options dialog box. Saves the problem specifications on the worksheet.

Syntax

SolverSave(SaveArea)

SaveArea is a reference on the active worksheet to a range of cells or to the upper-left corner of a column of cells into which you want to save the current problem specification.

Remarks

If you specify only one cell for SaveArea, the area is extended downwards for as many cells as are required to hold the problem specifications (3 plus the number of constraints).

If you specify more than one cell and the area is too small for the problem, the problem specifications will not be saved, and the function will return the value 2.

SaveArea must be on the active worksheet, but it need not be the current selection.