Need a code to solve the same function down multiple rows of data. I have the following but it does not seem to work. The formulas are set to change automatically and update frequently. I would like to learn how to continually loop the code to perform the same iteration up and down the rows with fluctuations in values.
Thanks!
For I = 45 to 50
SolverOk SetCell:="$B$" & I, MaxMinVal:=3, ValueOf:=Range(I "$F$6").Value, ByChange:= _ "$B$" & I
SolverSolve UserFinish:=True
Next I<strike></strike>
Thanks!
For I = 45 to 50
SolverOk SetCell:="$B$" & I, MaxMinVal:=3, ValueOf:=Range(I "$F$6").Value, ByChange:= _ "$B$" & I
SolverSolve UserFinish:=True
Next I<strike></strike>
