Using solver in vba to max value by changing weights? Help???
 

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.

Using solver in vba to max value by changing weights? Help???
 

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.

Using solver in vba to max value by changing weights? Help???
 

Thanks for the reply. Is there a way to have solver know which ones it should
use? Each time before solver runs the weights will change and some will have
values and the other ones will be zero. Is there a way to have solver change
only the cells with values in them? Thanks for the help

"Tom Ogilvy" wrote:

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.