Solver function from VBA

[ColourfulFigsnDiags]

Anyone know how to execute the solver function from VB? I tried recording a macro as I used solver, but when I run the macro it highlights the "SolverOK" command and comes up with an error saying "compile error: Sub or function not defined."

Any help would be greatly appriciated!

 

[ColourfulFigsnDiags]

Sorry ... figured it out ... if all else fails RTFM

"Before you use this function, you must establish a reference to the Solver add-in. With a Visual Basic module active, click References on the Tools menu, and then select the Solver.xla check box under Available References. If Solver.xla doesn't appear under Available References, click Browse and open Solver.xla in the \Office\Library\Solver\ subfolder."