Why is code Exiting?

[jim may]

I have a change event set up in sheet1

My enableevents is TRUE;

I;ve been sitting here for 5 minutes changing data in Columns D and E, yet
(while in Step mode) the Exit Sub is executed. Ideas why?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 4 Or Target.Column <> 5 Then Exit Sub
...more code follows

 

[kpark91]

Hi, Jim May.

If Target.Column <> 4 Or Target.Column <> 5 Then Exit Sub

This will be executed no matter because when there is an OR operator, if either one of the statement is true, then the if condition will run.
Just as a reminder, the code will execute when condition is true.

If condition Then
    code
End If

So, in your case, your condition was
Target.Column <> 4 Or Target.Column <> 5

Therefore, even if your target column is 4,
Target.Column <> 4 will return False while
Target.Column <> 5 will return True.
resulting into
If False Or True Then Exit Sub
same as
If True Then Exit Sub
allowing your code to exit the sub no matter what.

However, when you use And operator,
If False And True Then Exit Sub
same as
If False Then Exit Sub
as And operator requires both conditions to be satisfied in order to return True as a whole.

Therefore, you should use And instead of Or operator in this case.


Tips:
When you are using negativity in both conditions, Or and And operator will change with one another from when you're using positivity.
For example,
If Target.Column = 4 Or Target.Column = 5 Then
is opposite from
If Target.Column <> 4 And Target.Column <> 5 Then

I hope this helps.

 

[jim may]

Thanks again to ALL you guys (especially kpark92) for taking the time to offer such great explanations. This grass-roots logic always takes me "near the edge" of the abyss. LOL