Hi -

I recorded my step for Solver as a Macro (code below) and am trying to have the macro replicate the steps for all cells in column AJ (there will be 60K+ cells in the workbook). I have no real VBA skills to speak and I need help please! Thanks!

Sub Macro1()
'
' Macro1 Macro
'

'
SolverOk SetCell:="$AJ$2", MaxMinVal:=2, ValueOf:=5, ByChange:="$AJ$2", Engine _
:=1, EngineDesc:="GRG Nonlinear"
SolverOk SetCell:="$AJ$2", MaxMinVal:=2, ValueOf:=5, ByChange:="$AJ$2", Engine _
:=1, EngineDesc:="GRG Nonlinear"
SolverSolve
End Sub