LinkBack URL
About LinkBacks
How to add cell to value of option ??
How to add cell to value of option ??
Last edited by Heasham; 01-18-2016 at 02:29 PM.
This forum can be very strict about putting code in code tags. Edit your post to include these tags to avoid getting your topic locked.
Solver cannot accept a cell reference in the "value of" field. I usually add a helper cell current_Function-target_value, then have Solver set that cell to a value of 0.
Originally Posted by shg
Welcome to the board.
Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.
SolverOk SetCell:="$B$6", MaxMinVal:=3, ValueOf:=Range("A1").Value2
Entia non sunt multiplicanda sine necessitate
Thanks a lot i also usedand it workedDim i i = Cells(6, 3): SolverReset SolverOk SetCell:="$B$6", MaxMinVal:=3, ValueOf:=i, ByChange:="$B$4:$B$5", _ Engine:=1, EngineDesc:="GRG Nonlinear" SolverAdd CellRef:="$B$7", Relation:=2, FormulaText:="$C$7" SolverSolve End Sub
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks