Afternoon,

Would anyone be able to tell me why the following does not work?

Sub new_in()
'
' new_in Macro
If Range("R3") > "X" Then
Range("H3").Select
    Exit Sub
End If
 Application.Run "'Sheet1.xlsm'!arrive"
In cell R3 i have the formula that will show X if a condition is met, or stay blank if condition is not met.
So i was expecting the macro to stop running if R3 contained an X, but it does not, it instead continues onto the macro 'Arrive'

Any thoughts please

regards