Conditional solversolve

atyagi

New Member
Joined
Jun 21, 2005
Messages
26
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))
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,119,127
Messages
5,576,237
Members
412,709
Latest member
AD04
Top