Returns information about the current Solver problem. The settings are specified in the Solver Parameters and Solver Options dialog boxes, or with the other Solver functions described in this section.

Syntax

SolverGet(TypeNum, SheetName)

TypeNum is a number specifying the type of information you want. The following settings are specified in the Solver Parameters dialog box.

TypeNum Returns

1 The reference in the Set Cell box, or 0 if
Solver has not been used on the active document

2 A number corresponding to the Equal To option
1 = Max
2 = Min
3 = Value Of

3 The value in the Value Of box

4 The reference in the By Changing Cells box (only
the first entry in the Variables list box)

5 The number of entries in the Constraints list box

6 An array of the left sides of the constraints as text

7 An array of numbers corresponding to the relationships
between the left and right sides of the constraints:
1 = <=
2 = =
3 = >=
4 = int
5 = bin

8 An array of the right sides of the constraints as text

The following settings are specified in the Solver Options dialog box:

TypeNum Returns

9 The Max Time value (as a number in seconds)

10 The Iterations value (max number of iterations)

11 The Precision value (as a decimal number)

12 The integer Tolerance value (as a decimal number)

13 1 if the Assume Linear Model check box is selected;
0 otherwise.

14 1 if Show Iteration Result check box is selected;
0 otherwise

15 1 if Use Automatic Scaling check box is selected;
0 otherwise

16 A number corresponding to the type of Estimates:
1 = Tangent
2 = Quadratic

17 A number corresponding to the type of Derivatives:
1 = Forward
2 = Central

18 A number corresponding to the type of Search:
1 = Newton
2 = Conjugate

19 The Convergence value (as a decimal number) in the nonlinear
GRG Solver

20 1 if the Assume Non-Negative check box is selected;
0 otherwise

21 An array of the entries in the Variables list box as text

SheetName is the name of a worksheet that contains the Solver problem for which you want information. If SheetName is omitted, it is assumed to be the active sheet.