Hi Guys,
Thanks in advance as I know there is s'bdy out there who can help me.
I have to run slover in a macro and if it is not able to get a solution, i need to restore the original values otherwise keep the new values.
Something like this:
((
SolverSolve UserFinish:=True
If *****????
SolverFinish KeepFinal:=2
Else
SolverFinish KeepFinal:=1
End If))
Thanks in advance as I know there is s'bdy out there who can help me.
I have to run slover in a macro and if it is not able to get a solution, i need to restore the original values otherwise keep the new values.
Something like this:
((
SolverSolve UserFinish:=True
If *****????
SolverFinish KeepFinal:=2
Else
SolverFinish KeepFinal:=1
End If))