Also, this may be helpful:
http://peltiertech.com/Excel/SolverVBA.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Gary''s Student" wrote in message
...
Run Solver manually with the recorder turned on.
HOWEVER make sure that in VBA:
Tools References Solver is check first
--
Gary''s Student - gsnu200789
"Ali" wrote:
Any body knows how to run solver from a VBA macro?