Hi, I am running solver right now to maximize a value by changing multiple
weights. I have 24 weights. I want to put it in VBA and then kick it off and
have it run in a loop all weekend. My problem is that the weights are never
the same. Sometimes it may be by changing weights 3 through 12 and then the
next I will need to change weights 1 through 7 and 14 through 24. Is there a
way to have solver determine which cells to change each time in the values? I
do know which cells will need to be changed each time. It is in a spread
sheet.

I wasn't sure if an else if statement would work or what. Thanks for any
help you can give.