making a UDF that runs solver

M

maria bernal

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
 
M

Mike Middleton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Creating a macro that will run Solver. 0
Excel 2007: Help creating a macro that will run Solver? 3
Excel 2007: Help creating a macro that will run Solver? 0
Excel 2003 + Solver 3
Can UDF return a customized hyperlink? 3
I need help desperately !! I need a formula that will allow me to match cells... 2
Is there a single function that duplicates Solver? 1
Need Help with a VBA subroutine 0

Top