View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default 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