ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SolverOK, he not so OK (https://www.excelbanter.com/excel-programming/305538-solverok-he-not-so-ok.html)

toby

SolverOK, he not so OK
 
Anyone give us an idea about this one?. When I run this
basic macro, the settings of SolverOK do NOT get inputted
into the solver addin but the constraints do. (i.e.
SolverAdd works, SolverOK does not). If I manually record,
VBA recognises that I am using SolverOK and records my
actions, but when I play back, the macro totally ignores
the solverOK line. Any suggestions? Thanks Toby

Sub SolveMacro()
SolverReset
SolverAdd CellRef:="$B$1", Relation:=2,
FormulaText:="0.1"
SolverOK SetCell:="$A$1", MaxMinVal:=1, ValueOf:="0",
ByChange:="$C$1:$C$4"
SolverSolve True
End Sub
..




All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com