I have over 100 cells in a workbook that require Solver to update my
solution. I am doing each one manually. Is there a Solver function that will
automate this process. I want to automatically recalculate with each change
to a worksheet.
--
Dave

I have a Solver model that updates 360 cells. But to give any meaningful
help, we would need to know more about your model
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"LaRue" wrote in message
...
I have over 100 cells in a workbook that require Solver to update my
solution. I am doing each one manually. Is there a Solver function that
will
automate this process. I want to automatically recalculate with each
change
to a worksheet.
--
Dave

If you look at how solver sets models, you can use that information to
set it up programmatically, then load the model from this range you
make.

The range is in a single column. First cell points to the value to
solve. Second cell contains the addresses of values to change. After
this, the constraints are listed in as many cells as needed. Finally,
you have an array in this order:

{max_time, iterations, precision, tolerance, assume_linear,
show_iteration, auto_scaling, estimates, derivatives, search,
convergence, assume_nonnegative}

Note that estimates, derivatives, and search options are listed as 1
or 2 (respectively for top and bottom option). The checkbox options
are stored as TRUE or FALSE.

For doing it via VBA, see this:

http://support.microsoft.com/kb/843304


On Nov 16, 12:59 am, LaRue wrote:
I have over 100 cells in a workbook that require Solver to update my
solution. I am doing each one manually. Is there a Solver function that will
automate this process. I want to automatically recalculate with each change
to a worksheet.
--
Dave