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.

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.

Search XL help for any Solver command (such as SolverSolve). One of
the first few sentences will tell you what references you need to
establish to correctly access Solver from VBA.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , =?Utf-
8?B?S2VudCBHYW1icmVs?= <Kent says...
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.