Two ByChange ranges in SetCell command (solver)

[ue418]

I have two noncontiguous ranges in a SetCell, ByChange command for Solver. I am trying the following:



SolverOk SetCell:="$U$" & r, MaxMinVal:=3, ValueOf:="0", ByChange:= _
"$v$" & r & ":$x$" & r, "$L$" & r & ":$q$" & r

where "r" is an integer that I am using for looping. Just assume it is 1 for the moment. So, I have two ranges, columns L thru Q, and columns V thru X. It keeps giving me a "require named parameter" error. I also tried to specify V1, W1 and X1 individually, but no matter what I do, I get that error. Could someone show me the proper syntax when you have two separate ranges in the ByChange region of the SetCell command? Thank you so much.

Rick

[ue418]

Hello everyone. I now have a slightly different problem, but hopefully easier? I now have a noncontiguous range, for my "changing" cells/columns in the SolverOK command. That is, I am changing columns N through T, but NOT including S! So I can do the range code for N thru R, but then I need to also specify column T as "changing". Of course, this is all in the SolverOk SetCell command, as described in my original post. Can anyone tell me how to "connect" the range specification with the single cell/column specification, in that command? Thank you so much.

Rick