Error message

The page you requested does not exist. For your convenience, a search was performed using the query category catalog excel products.

Search results

Excel Solver- SolverOk Function

Defines a basic Solver model. Equivalent to clicking Solver in the Data | Analysis group and then specifying options in the Solver Parameters dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basi ...

admin - 04/07/2015 - 15:04

Excel Solver- SolverOkDialog Function

Same as the SolverOK function, but also displays the Solver dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then selec ...

admin - 04/07/2015 - 15:04

Excel Solver- SolverOptions Function

Allows you to specify advanced options for your Solver model. This function and its arguments correspond to the options in the Solver Options dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basi ...

admin - 04/07/2015 - 15:04

Excel Solver- SolverReset Function

Resets all cell selections and constraints in the Solver Parameters dialog box and restores all the settings in the Solver Options dialog box to their defaults. Equivalent to clicking Reset All in the Solver Parameters dialog box. The SolverReset function ...

admin - 04/07/2015 - 15:04

Excel Solver- SolverSave Function

Saves the Solver problem specifications on the worksheet. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select the Solver.x ...

admin - 04/07/2015 - 15:05

Excel Solver- SolverSolve Function

Begins a Solver solution run. Equivalent to clicking Solve in the Solver Parameters dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the To ...

admin - 04/07/2015 - 15:05

Excel Solver- Interpreting the Sensitivity Report

The Sensitivity Report provides classical sensitivity analysis information for both linear and nonlinear programming problems, including dual values (in both cases) and range information (for linear problems only).  The dual values for (nonbasic) variable ...

admin - 01/06/2024 - 15:28

Pages