Excell: macro to handle Solver errors

[tab245]

Hi!

I am fairly new to VBA, and I would appreciate any advice.

I have recorded a macto to run SOLVER. However, I do not know how to read SOLVER results automatically. I mean, how to check if SOLVER solution converges or not.

I added the lines that takes solver control from the user:
' Do not display the Solver Results dialog box.
SolverSolve UserFinish:=True

' Finish and keep the final results.
SolverFinish KeepFinal:=1

Is there any way to check if SOLVER solution converges - before the final result is recorded?

Thank you!

Tanya

 

[tab245]

O'k!
I just got the answer:

I should check the value of SolverSolve. I can use something like this:

If SolverSolve <> 0 Then Stop

Thank's anyhow!

Tanya