Don't know if this will help, but when I have a loop of some sort using
Solver, I clear the existing Solver model with a SolverReset at the top
of the list. Then, I create the next one customized to the conditions
specific to the current loop.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have written my solver to work in a loop. During each loop I need to adjust size of the "By Changing Cells" array and also one of the constraints. I have no problems with getting the program to adjust the "By Changing Cells" array. The constraint however is different.

I have my program change the formula in the saved model area to accomadate the new array size, (it looks like this {=G44:G61=0}). Now, when I load the saved model, I get this error "SOLVER: An Unexpected internal error occurred, or available memory was exhausted". It doesn't matter if I try to load a model after the program has adjusted my new constraint or if I type in all my constrains it the main solver
form then save them then try to reload them. I get the same error.

Can anyone give me some advice? Or do I have to have my program write a constraint for each cell in the array (i.e. =G44=0, =G45=0, . . . , =GXX0)