Any body knows how to run solver from a VBA macro?
G Gary''s Student May 30, 2008 #2 Run Solver manually with the recorder turned on. HOWEVER make sure that in VBA: Tools > References > Solver is check first
Run Solver manually with the recorder turned on. HOWEVER make sure that in VBA: Tools > References > Solver is check first
J Jon Peltier May 30, 2008 #3 Also, this may be helpful: http://peltiertech.com/Excel/SolverVBA.html - Jon
