G Guest Jan 18, 2006 #1 The macro seems to always stop at the solver results dialogue box even though I want it to automatically keep the solver solution.
The macro seems to always stop at the solver results dialogue box even though I want it to automatically keep the solver solution.
T Tushar Mehta Jan 18, 2006 #2 The macro seems to always stop at the solver results dialogue box even though I want it to automatically keep the solver solution. Click to expand... 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
The macro seems to always stop at the solver results dialogue box even though I want it to automatically keep the solver solution. Click to expand... 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
