"Worksheet_Change, If not intersect" question

[PATSYS]

Hi all,

I have a worksheet_Change event in my sheet.

I would like that if values are being entered in either J3 or J5 and if the rightmost value is not "\" then the code should add the "\" at the end of either J3 or J5 (depending on which one is being updated.

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("J3,J5")) Is Nothing Then

         ???
         ???
                
    End If


End Sub

Thanks

 

[PATSYS]

Hi all,

Sorry for all the confusion. The reason why it did not work is that my code says:

If not intersect...

when it should be

If intersect...

as Mick earlier suggested.