Microsoft KB Archive/136736

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.