solver

[scottscott]

I am using solver in a macro and after i run solver it always prompts to ask if the solution is okay. I would just like to accept the solution. I tried using Application.DisplayAlerts = False but i still get the prompt. Is there a way to click ok through vba?

 

[PHV]

What is your actual code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[scottscott]

'Solve Aexp(ct^B)
SolverOk SetCell:="$E$2", MaxMinVal:=2, ValueOf:="0", ByChange:="$E$1:$G$1"
SolverSolve

'Solve for the half life
SolverOk SetCell:="$K$1", MaxMinVal:=3, ValueOf:=".5", ByChange:="$I$1"
SolverSolve

After each SolverSolve a dialog box pops up.

 

[combo]

SolverSolve UserFinish:=True

Seee details in

http://support.microsoft.com/kb/843304

combo

 

[scottscott]

Thanks just what i wanted!