Microsoft KB Archive/136736

From BetaArchive Wiki
Knowledge Base


SolverGet and Solver.Get Do Not Return References

Article ID: 136736

Article Last Modified on 8/15/2003



APPLIES TO

  • Microsoft Excel 95a
  • Microsoft Excel 5.0c
  • Microsoft Excel 4.0a
  • Microsoft Excel 5.0a for Macintosh
  • Microsoft Excel 4.0 for Macintosh



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.


Additional query words: 4.00a 5.00c XL7 XL5 XL4 XL

Keywords: KB136736