ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Solver (https://www.excelbanter.com/excel-discussion-misc-queries/189343-solver.html)

Ali

Solver
 
Any body knows how to run solver from a VBA macro?

Gary''s Student

Solver
 
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?


Jon Peltier

Solver
 
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?





All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com