VBA Solver for multiple rows? HELP

[apitten1]

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>