Hi again,

If i change the code:

SolverAdd CellRef:="$R$33", Relation:=2, FormulaText:=Cells(17, y)
to

SolverAdd CellRef:="$R$33", Relation:=2, FormulaText:="AE$17"
It works, but for every iteration i need for AE17 to change on cell to the right (i.e next cell to be in the solver is AF17). Can i somehow code so that the second one "AE$17" changes one cell to the right in the next for-sling?