Equivalent to making selections and clicking OK in the Solver Results dialog box that appears when the solution process is finished. The dialog box will not be displayed.

Syntax

SolverFinish(KeepFinal, ReportArray)

KeepFinal is the number 1 or 2 and specifies whether to keep or discard the final solution. If KeepFinal is 1 or omitted, the final solution values are kept in the changing cells. If KeepFinal is 2, the final solution values are discarded and the former values of the changing cells are restored.

ReportArray is an array argument specifying what reports to create when Solver is finished.

If ReportArray is 1-2-3 creates
1 An Answer Report
2 A Sensitivity Report
3 A Limits Report

A combination of these values produces multiple reports. For example, if ReportArray(1) = 1 and ReportArray(2) = 3, 1-2-3 creates an Answer Report and a Limits Report.