Novice Solver Loop Question

[Emmur]

Hi all,

I'm a true novice with Excel, so hopefully this query is laughably easy to solve.

I have a macro set up for Solver to run over a column of data. I want to loop Solver such that it runs this process iteratively (dragging the columns of calculations across several rows).

SolverReset
SolverOk SetCell:="$M$4", MaxMinVal:=2, ValueOf:=0, ByChange:="$M$7:$M$9", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverAdd CellRef:="$M$10", Relation:=2, FormulaText:="1"
SolverAdd CellRef:="$M$3", Relation:=2, FormulaText:="$M$2"
SolverOk SetCell:="$M$4", MaxMinVal:=2, ValueOf:=0, ByChange:="$M$7:$M$9", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverSolve

The value of L2 is changing across the rows (relative reference), while cells M3:M5 contain formulae which must be consistent across all of the cells (absolute reference).

Hopefully that's enough information. How should I go about getting a loop to function? Thank you!!

[Emmur]

Bump.

Please let me know if this doesn't make sense or if more information is required.

[Alf]

The value of L2 is changing across the rows

Can't see any reference to L2 in you solver setup. Could you upload the file perhaps?

Alf