Worksheet change event not responding to cell deletion

**jman0707** · 11-13-2008, 02:00 PM

I have a code (thanks royUK and Leath!) where column K is not responding to a value being deleted out of column J. I've highlighted the portion of the code dealing with this. Deletion should trigger the worksheet_change event to clear out column K as it's supposed to. Any ideas on how to get deletion to take effect? Thanks!

Please Login or Register  to view this content.

I've attached the workbook as well.

**VBA Noob** · 11-13-2008, 02:04 PM

I see you have Rng 3 set but not used in the Intersect so guess that is the problem

Please Login or Register  to view this content.

VBA Noob

**jman0707** · 11-13-2008, 02:50 PM

So do I need to change this line of code:

Please Login or Register  to view this content.

to this?

Please Login or Register  to view this content.

**VBA Noob** · 11-13-2008, 03:05 PM

No

This line is the trigger for Range("J17:J116")

Please Login or Register  to view this content.

If you want to trigger for two different ranges you would do something like
the below. This triggers a message for example if you select a cell in Col A or C

Please Login or Register  to view this content.

VBA Noob

**jman0707** · 11-13-2008, 03:22 PM

OK, I changed it to the following, and now when I change the value in E it does clear out the cell, BUT it still doesn't work when I delete the value in J (doesn't clear K like it should). And seeing how intersect(target, column J) was already a trigger, it should already work but I need to find out why it's not. Any ideas? Thanks VBNoob!

Please Login or Register  to view this content.

Worksheet change event not responding to cell deletion

LinkBack

Thread Tools

Rate This Thread

Display

Worksheet change event not responding to cell deletion

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions