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

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

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

--
Regards,
Tom Ogilvy

"Michael" wrote in message
...
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

Thank you so much!!!

Have a great weekend and God bless.

Michael

-----Original Message-----
did you set a reference to the solver addin in
tools=references in the VBE?

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

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

--
Regards,
Tom Ogilvy

"Michael" wrote in
message
...
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


.