Macro Sheets Only
Equivalent to choosing OK in the Solver Results dialog box that appears when the solution process is complete. The dialog-box form displays the dialog box with the arguments that you supply as defaults. This function must be used if you supplied the value TRUE for the userfinish argument to SOLVER.SOLVE.
If this function is not available, you must install the Solver add-in macro.
Syntax
SOLVER.FINISH(keep_final, report_array)
SOLVER.FINISH?(keep_final, report_array)
Keep_final is the number 1 or 2 and specifies whether to keep the final solution. If keep_final is 1 or omitted, the final solution values are kept in the changing cells. If keep_final is 2, the final solution values are discarded and the former values of the changing cells are restored.
Report_array is an array argument specifying what reports to create when Solver is finished.
If report_array is Microsoft Excel creates
{1} An answer report
{2} A sensitivity report
{3} A limit report
Any combination of these produces multiple reports. For example, if report_array is {1, 2}, Microsoft Excel creates an answer report and a sensitivity report.
Related Functions
SOLVER.SOLVE Equivalent to choosing the Solver command from the Tools menu and choosing the Solve button in the Solver Parameters dialog box
List of Command-Equivalent Functions