SolverSolve return values

[Guest]

I have a macro where I use the Solver multiple times. I would like to
capture the value that SolverSolve returns (I understand that there are 1 of
13 values returned by the SolverSolve command) in order to determine how my
macro should respond. Does any know how to capture the returned value? I
currently use the following:

If SolverSolve(UserFinish:=True) = 4 Then.....

This works but if I use this approcah for each condition the SolverSolve
command appears to run for each statement. I would like to capture this
returned value to evaluate without re-running the solver for each test.

Thanks for you help.
Steve

 

[Jon Peltier]

Dim iSolverSolve As Long
iSolverSolve = SolverSolve(UserFinish:=True)
Select Case iSolverSolve
etc.

- Jon