SolverAdd( CellRef, Relation, FormulaText)ĬellRef Required Variant. 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, the Solver add-in must be enabled and installed. Note The Solver add-in is not enabled by default. Equivalent to clicking Solver in the Data | Analysis group and then clicking Add in the Solver Parameters dialog box. Adds a constraint to the current problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |