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

 

[VoG]

Try

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

 

[diddi]

should your 'or' be an 'and' ?

 

[CharlesChuckieCharles]

Target.Column <> 4 Or Target.Column <> 5

4 is not equal 5 and visa versa

TRY

(Target.Column <> 4) AND (Target.Column <> 5)

(Target.Column < 4) Or (Target.Column > 5)

 

[RoryA]

Better yet:

If Not Intersect(Target, Range("D:E")) Is Nothing then
' run your code
End If

 

[jim may]

Sorry, but

Thanks to all;

But to CharlesChuckieCharles...

Target.Column <> 4 Or Target.Column <> 5

seems (right now) logical to me; seems like I've used this logic before, havn't I?

and I don't quite get the "4 is not equal 5 and visa versa" follow thru..

I'm pretty THICK, can you put this in "imbecil" terms?

 

[VoG]

If you are in column 4

Target.Column <> 5

is true and you exit.

If you are in column 5

Target.Column <> 4

is true and you exit.

If you want to check if you are in either column you need And not Or.

 

[CharlesChuckieCharles]

when the column is 4 Target.Column <> 4 =false but Target.Column <> 5
is true and with a OR only one statement has to be true
and visa versa

 

[diddi]

if the target column is not 4, and also, the target column is not 5 then it is neither 4 nor 5 , and so exit sub.

you are using negative logic.

positive logic:
if target IS 4 or target IS 5 then it is ok to continue

 

[RoryA]

Put another way, the column cannot be both 4 and 5 so one of the Or statements must always be true.