Solver Macro

[Michael]

How do I program the Solver in VBE? When I run the macro
recorder and then run the solver, the code that comes out
seems fine, but it won't run as a macro, giving me the
error that the first token "SolverOK" is undefined. There
must be a better way to envoke the Solver, which in my
case, does have hardcoded cell refs.

Thanks for your help so much!!

Michael

 

[Tom Ogilvy]

did you set a reference to the solver addin in tools=>references in the VBE?

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