http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver

http://www.frontsys.com/xlhelp.htm
Help for Microsoft Excel Solver Users

Sounds like you need to create a reference as stated in the first article.

--
Regards,
Tom Ogilvy

"Kent Gambrel" <Kent wrote in message
...
I have 2-4 options of solver I wish to use depending on a cell's value.
Would like to use a macro, but keep getting compile errors on the Solver
commands in VBA.