Sub Optimizator()
'
' Test_Solveur Macro
'
Dim wsFM_B3 As Worksheet
Set wsFM_B3 = ThisWorkbook.Worksheets("xxx_B3")
Dim j As Integer
For j = 0 To Range("Years").Value
SolverReset
SolverAdd CellRef:=wsFM_B3.Range("E_Start").Offset(0, j), Relation:=3, FormulaText:= _
"'$E$7"
SolverAdd CellRef:=wsFM_B3.Range("Bank_Start").Offset(0, j), Relation:=3, FormulaText:="Cash_B3"
SolverOk SetCell:=wsFM_B3.Range("PoY_Start").Offset(0, j), MaxMinVal:=3, ValueOf:=0, ByChange:=wsFM_B3.Range("CC_Base_Start").Offset(0, j), Engine _
:=1, EngineDesc:="GRG Nonlinear"
SolverSolve True
Next j
End Sub