Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Code To Stop Solver Results Dialog Box Showing

Status
Not open for further replies.

ADE6

Programmer
Apr 4, 2004
93
GB
Hi,

Does anybody know how to stop the Solver Results Dialog Box appearing ?

I want to accept the solver results and carry on with the rest of my macro.

Really appreciate the help


Ade







Code:
Sub METASTOCKSOLVER() 
     
    Sheets("CALC").Select 
    SolverOk SetCell:="$F$21", MaxMinVal:=1, ValueOf:="0", ByChange:="$B$21" 
    SolverSolve 
    SolverSolve UserFinish:=True 
End Sub
 
I seem to have sorted it out.

By removing "SolverSolve" it seems to work
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top