How do I automatically accept a solver solution in a macro?
 

The macro seems to always stop at the solver results dialogue box even though
I want it to automatically keep the solver solution.

How do I automatically accept a solver solution in a macro?
 

In article ,
says...
The macro seems to always stop at the solver results dialogue box even though
I want it to automatically keep the solver solution.

Check out XL VBA help for the SolverSolve function, particularly, its
UserFinish argument.

You may also want to check out the SolverFinish function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions