Worksheet change event not responding to cell deletion

What sheet has that code?

My simple routine to check A1 using IsEmpty() worked fine.

Not sure why you are looping through several cells if just one in the target group was changed.

Kenneth - Sheet3, AKA "NML Inventory" has the code. And I only typed in a portion of the macro in my first post. Thanks!

And I think the person that helped me with this had it check them all upon worksheet change is because when you filter or sort it changes the locations of all the entries, and the value in all cells in K need to follow their buddy cells in J??? That is what needs to happen, so maybe that's why it's written like that. Let me know your thoughts on a remedy once you check out the worksheet. Thanks for your help!

I tried to use it in Excel 2003 and it couldn't exit design mode due to Commandbutton3. Maybe you can save just sheet1 and sheet3 to an xls.

Your Compile button in the VBE should be greyed. Mine is not because it won't compile.

Here try this one. I unprotected the worksheet, so maybe that will help. I can't just post the worksheet because they are all tied in together. But I also pasted the full code below so maybe you can re-adjust it to just evaluate the line that the target changes. It isn't in design mode either. I also realized that it wouldn't need to run the macro after a filter/sort because each row would move completely together. So you might be right about just doing one line at a time, it might get the delete to take effect, and may perhaps speed up the macro. Let me know your thoughts!

Please Login or Register  to view this content.

I figured it out. I added this following code to the bottom of the event. It turns out that for some reason it likes the columns wording better than naming a range. I know it's probably redundant, but it works!

Please Login or Register  to view this content.