http://office.microsoft.com/en-us/ex...CL100570551033

I think you can see that each time you run solver, if the definition of the
changing cells is going to change, you would need to configure solver to
know which cells to use.

If your not going to be there to do it, you will need to write code to
manage solver.

--
Regards,
Tom Ogilvy

"Need Help Fast!" wrote in message
...
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.