vba solver

[ttran123]

Hi there,

I'm new the forum so I apologize if the code below doesn't make sense. I would like the variable cell to be ascending




Sub year1()
'
' year1 Macro
'


'
SolverOk SetCell:="$P$36", MaxMinVal:=3, ValueOf:=0, ByChange:="$B$6:$B$16", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverOptions MaxTime:=0, Iterations:=0, Precision:=0.000001, Convergence:= _
0.0001, StepThru:=False, Scaling:=True, AssumeNonNeg:=True, Derivatives:=1
SolverOptions PopulationSize:=100, RandomSeed:=0, MutationRate:=0.075, Multistart _
:=False, RequireBounds:=True, MaxSubproblems:=0, MaxIntegerSols:=0, _
IntTolerance:=1, SolveWithout:=True, MaxTimeNoImp:=30
SolverOk SetCell:="$P$36", MaxMinVal:=3, ValueOf:=0, ByChange:="$B$6:$B$16", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverOk SetCell:="$P$36", MaxMinVal:=3, ValueOf:=0, ByChange:="$B$6:$B$16", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverSolve
End Sub