Thread: Solver Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michael michael is offline
external usenet poster
 
Posts: 28
Default Solver Macro

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