Worksheet Change Event Wrongly Trigger

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.

Please Login or Register  to view this content.

Then, my next confusion is should I choose Worksheet SelectionChange or Change as both seems to have the same output

Try This...

Please Login or Register  to view this content.

Hi Debraj,

Thanks a lot


My last question is Worksheet SelectionChange or Change seems to have the same output. what is the differences?

Please Login or Register  to view this content.

test this one in a blank sheet..