Solver

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
Back
Top