XL98: Unexpected Results Using the SolverAdd Function

ID: Q190192

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, when you run the SolverAdd function to programmatically add a constraint in your Solver model, the constraint is not added.

CAUSE

This problem may occur if you use R1C1 notation for the "FormulaText" argument of the SolverAdd function. In Microsoft Excel 98, the "FormulaText" argument for SolverAdd will run successfully when it is in A1 notation.

NOTE: In earlier versions of Microsoft Excel, When you add a constraint to a problem with the Visual Basic function SolverAdd, you are required to specify the right side of the equation (the "FormulaText" argument) in R1C1 notation. If you do not specify the "FormulaText" argument in R1C1 notation, the constraint is not added. However, in Microsoft Excel 98, you must use A1 notation.

WORKAROUND

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact the Microsoft fee-based consulting line at (800) 936-5200. For more information about the support options available from Microsoft, please see the following page on the World Wide Web:

http://www.microsoft.com/support/supportnet/overview/overview.asp

For example, the following line will not add a constraint to a Solver model in Microsoft Excel 98:


   SolverAdd CellRef:=Range("$A$1"), Relation:=1, FormulaText:="R1C2"

To correct this problem, change the FormulaText argument to A1 notation, such as the following example:


   SolverAdd CellRef:=Range("$A$1"), Relation:=1, FormulaText:="$B$1"

Additional query words: addin XL98

Keywords : kbprg kbdta xlvbainfo xladdins
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb