Solver formula "Equal to Value of:" cell reference

  • Thread starter Thread starter ORLANDO VAZQUEZ
  • Start date Start date
O

ORLANDO VAZQUEZ

Hi !

Is there a way I can use Solver in a vb formula so that the "Value of" value
equals a cell reference?

Thank you.
 
For example, the ValueOf:= below should reference a cell on the spreadsheet
that contains the value instead of having to type in the value.

Sub solvit()
SolverReset
SolverOk SetCell:=("J16"), MaxMinVal:=3, ValueOf:=0.0125, ByChange:=("N16")
End Sub
 
An untested suggestion

Sub solvit()
SolverReset
val =Range("N16)
SolverOk SetCell:=("J16"), MaxMinVal:=3, ValueOf:=val, ByChange:=("N16")
End Sub

best wishes
 
Back
Top