SOLVER.SAVE

Macro Sheets Only

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

If this function is not available, you must install the Solver add-in macro.

Syntax

SOLVER.SAVE (save_area)

Save_area is a reference on the active sheet to a range of cells or to the upper-left corner of a range of cells into which you want to paste the current problem specification.

• If you specify only one cell for save_area, 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 if the area is too small, the last constraints (in alphabetic order by cell reference) or options will be omitted and the function will return a nonzero value.
• Save_area must be on the active worksheet, but it need not be the current selection.

Related Functions

List of Command-Equivalent Functions