How do I start solver options in a Macro?

[Guest]

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.

 

[Tom Ogilvy]

http://support.microsoft.com/support/excel/content/solver/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.

 

[Tushar Mehta]

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