Numerical Analysis
 

There is a "solve" section in tools, but it seems to be static. May I know
how to make it dynamic output based on dynamic source in VBA?

Numerical Analysis
 

In the VBA help the is examples. Here is one of them

Worksheets("Sheet1").Activate
SolverReset
SolverOptions Precision:=0.001
SolverOK SetCell:=Range("TotalProfit"), _
MaxMinVal:=1, _
ByChange:=Range("C4:E6")
SolverAdd CellRef:=Range("F4:F6"), _
Relation:=1, _
FormulaText:=100
SolverAdd CellRef:=Range("C4:E6"), _
Relation:=3, _
FormulaText:=0
SolverAdd CellRef:=Range("C4:E6"), _
Relation:=4
SolverSolve UserFinish:=False
SolverSave SaveArea:=Range("A33")


"Ryusuke" wrote:

There is a "solve" section in tools, but it seems to be static. May I know
how to make it dynamic output based on dynamic source in VBA?