how to exit/quit macro after a if statement?

[welkin]

I have below if statement and if this is true, i want to exit the macro after executing without going to the rest of the codes after end if.


If Range("B2") = "abc" Then

Range("A2").Value = "abc" & Format(today, "ddmmyy")
Range("B2:E2").Select
Selection.ClearContents

End If

is there a way to skip to end sub()? or should I replace the if statement with something else?

Many Tks in advance.

 

[DonkeyOte]

use Exit Sub before End If

 

[Peter_SSs]

welkin

There may be a more "elegant" way to deal with this. What else does your code do if B2 is not equal to "abc"?

If your code is not too long, perhaps you could post it here? If so, please use code tags around your code to make it easier to read. [ code ] (without spaces) before your code and [ /code ] (without spaces) after your code.

 

[welkin]

Thanks both.

Exit sub works perfectly.

I tired exit previously but i missed out the "sub" and hence it did not work.