XL: SolverGet and Solver.Get Do Not Return References

• Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 5.0c
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for the Macintosh, versions 4.0, 5.0, 5.0a

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.