Solver: Can't add constraints when they are above/below certain va

C

CK

Hi, I am writing a VBA code in attempt to find some optimal values within
certain boundaries. To do this, I call Solver in VBA and add the constraints
using the following code:

SolverAdd CellRef:=Range("beta").Address, Relation:=1,
FormulaText:="UpperBound"
SolverAdd CellRef:=Range("beta").Address, Relation:=3,
FormulaText:="LowerBound"

where "LowerBound" and "UpperBound" refers to two cells containing the
boundaries.

The interesting thing is, when the LowerBound (or Upperbound) is below (or
above) certain value, then the constraint is not added into Solver.

Does anyone have any idea why this happens?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set solver constraint not working in VB 6
Macro for solver on certain worksheets 2
Regarding excel and VBA 1
Macro Skip the Constraint (Solver) 0
Solver ignores constraints in protected sheets XL 2003 1
VBA code to RUN Solver mutiple times (on different target cells) 8
Need advice on Solver loop 1
Excel Solver in VB 4

Top