SolverGet and Solver.Get Do Not Return References (136736)
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows 4.0a
- Microsoft Excel for the Macintosh 5.0a
- Microsoft Excel for the Macintosh 4.0
This article was previously published under Q136736 SYMPTOMS
In Microsoft Excel Visual Basic for Applications, the SolverGet function
returns information about the current Solver settings. In the Microsoft
Excel 4.0 macro language, the Solver.Get function returns this same
information. Both of these functions use the Type_Num argument to specify
what information to return. Using SolverGet or Solver.Get with a Type_Num
argument of 1 or 4 should return cell references; however, the values in
the cells that were referenced are returned instead.
STATUS
This is a known problem in the versions of Microsoft Excel listed at the
beginning of this article. This problem was corrected in Microsoft Excel 97
for Windows and Microsoft Excel 98 Macintosh Edition.
MORE INFORMATION
For example, both Typenum 1 and Typenum 4 return the values in the cells
that were referenced in the Solver box instead of the cell references.
Typenum 1 should return the reference in the Set Cell box, or the #N/A
error value if Solver has not been used on the active sheet; and Typenum 4
should return the reference (as a multiple reference if necessary) in the
By Changing Cells box.
Note that Typenum 1 and Typenum 4 do correctly return the #N/A error value
if Solver hasn't been used on the active sheet.
| Modification Type: | Minor | Last Reviewed: | 8/15/2003 |
|---|
| Keywords: | KB136736 |
|---|
|