![]() |
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