I'm working on a spreadsheet that needs to run solver for all the cells in a
column. I just can't do it one by one because I'll be using the spreadsheet
under different conditions. Can anyone tell my how to program a UDF that
will run solver so I can drag it down the column? Thanks!

url:http://www.ureader.com/gp/1042-1.aspx

maria bernal -

I doubt that you can use a User Defined Function to run Solver.

A UDF can only return a value to the cell where it resides. When Solver
runs, Solver changes values in other cells.

So, I think you will have to use a subroutine instead of a UDF.

Examples and tutorials are available if you search Google for "excel vba
solver" (without the quotes).

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"maria bernal" wrote in message
.. .
I'm working on a spreadsheet that needs to run solver for all the cells in
a
column. I just can't do it one by one because I'll be using the
spreadsheet
under different conditions. Can anyone tell my how to program a UDF that
will run solver so I can drag it down the column? Thanks!

url:http://www.ureader.com/gp/1042-1.aspx