SOLVER.LOAD

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 Load Model button in the Solver Options dialog box. Loads Solver problem specifications that you have previously saved on the worksheet.

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

Syntax

SOLVER.LOAD(load_area)

Load_area is a reference on the active sheet to a range of cells from which you want to load a complete problem specification.

• The first cell in load_area contains a formula for the Set Cell box; the second cell contains a formula for the changing cells; subsequent cells contain constraints in the form of logical formulas. The last cell optionally contains an array of Solver option values. The order of the Solver option values is the same as the top-to-bottom order in the Solver Options dialog box.
• Although load_area must be on the active sheet, it need not be the current selection.

Related Functions

List of Command-Equivalent Functions