![]() The last cell optionally contains an array of Solver option values. ![]() The first cell in the LoadArea contains a formula for the Set Target Cell box in the Solver Parameters dialog box the second cell contains a formula for the By Changing Cells box subsequent cells contain constraints in the form of logical formulas. A reference on the active worksheet to a range of cells from which you want to load a complete problem specification. If Solver does not appear under Available References, click Browse, and then open Solver.xlam in the \Program Files\Microsoft Office\Office14\Library\SOLVER subfolder. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select Solver under Available References. After the Solver add-in is installed, you must establish a reference to the Solver add-in. For information about how to do that, see Using the Solver VBA Functions. Before you can use this function, you must have the Solver add-in enabled and installed. Note The Solver add-in is not enabled by default. Loads existing Solver model parameters that have been saved to the worksheet.
0 Comments
Leave a Reply. |