Macro not responding to cell deletion

I have a code (thanks royUK and Leath!) where, if column E is "Annuity", you can type a value in column J and it runs a formula to calculate a value for column K. If E is not "Annuity" it clears the contents of J (which should clear K). What's not working is when column J gets cleared or manually deleted, column K must be blank. The worksheet_change event is not working for deletion of column J. Thanks!

Please Login or Register  to view this content.

I don't think that deleting a cell's value will trigger the event. maybe if you try the Calculate event

So do you suggest taking out the following part of the worksheet_change event and doing this instead?

Please Login or Register  to view this content.

Yeah it's not working for me. I don't know the proper syntax with this type of event. Here's what it's telling me.

Compile Error: Prodecure declaration does not match description of event or procedure having the same name.

Any ideas?

Attach an example workbook

Here you go! Column K is not responding when column J gets deleted. It should trigger, since it's the worksheet_change event....