Hey guys,
I have macro which is looping solver on every row, code is :
Sub SOLVER()
'
' SOLVER Makro
'
'
Dim i As Integer
For i = 1 To 500
SolverReset
SolverOk SetCell:="$Y$" & i, MaxMinVal:=2, ByChange:="$J$" & i & ":$K$" & i, _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverAdd CellRef:="$J$" & i & ":$K$" & i, Relation:=3, FormulaText:="$L$" & i
SolverAdd CellRef:="$J$" & i, Relation:=1, FormulaText:="$M$" & i
SolverAdd CellRef:="$K$" & i, Relation:=1, FormulaText:="$N$" & i
SolverSolve Userfinish:=True
Next
End Sub
The problem is, that I have approx. 70.000 rows and it took EXCEL like 20 mins to solve these 500 test rows. Is there any way how to do it faster? If possible, write the specific code please since I´m not very experienced with VBA (Actually I wouldn´t have even this without ALF ).
Thank you so much!
Bookmarks