MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Solver as a function?

Posted by Mark Marshall on February 14, 2002 8:19 AM

I want to write a function that will solve by varying a cell to make another =0, like using the goal seek under tools. However, I can't find any reference to the Solver() functions in the function menu..

Any idea how to make this work?

Many thanks.

Posted by Larry Kramer on February 14, 2002 3:15 PM

You can put a goalseek in a macro. Just turn on the recorder and do your thing and look at the resulting code.