Hi,
I am writing Worksheet Change Event to enable auto trigger to clear contents from column "SC" to "TB" if user clear contents column "B" to "I".However, there is a bit error whereby the sheet will be triggered even if user clear contents for only one column between "B" to "I"
Before this, i have used If Range("B" & i & ":I" & i) Is Empty Then but it does not work 
For the beginner like me, I am a bit confused on the term If Not Intersect(Target, Range()) Is Nothing Then
Here is my code.
Private Sub Worksheet_Change(ByVal Target As Range)
i = ActiveCell.Row
If Not Intersect(Target, Range("B" & i & ":I" & i)) Is Nothing Then
Range("SC" & i).Resize(1, 26).ClearContents
End If
End Sub
Then, my next confusion is should I choose Worksheet SelectionChange or Change as both seems to have the same output
Bookmarks