| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver: Can't add constraints when they are above/below certain va
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Solver Constraints | Excel Discussion (Misc queries) | |||
| Constraints in Excel Solver | Excel Worksheet Functions | |||
| Solver Constraints | Excel Discussion (Misc queries) | |||
| Solver not Using Constraints when called from VB | Excel Programming | |||
| Solver constraints not added | Excel Programming | |||
Threaded Mode
