Help with Solver Code
I am using a solver reference in my code like this:
SolverOk SetCell:="$c$22", MaxMinVal:=3, ValueOf:="0", ByChange:="$c$18"
SolverSolve (True)
However I need to do this repetitively so I would like to change $c$22 to
something like (looper+5,5). However, when I try to use a cell reference like
that, I get an error message. Thanks for the help.
--
Paul
|