Clearing a cell that triggers Worksheet_Change event

[malcmail]

I have the following code in my sheet:

Please Login or Register  to view this content.

Those cells are dropdown choices - repayment or advance. It works perfectly, except..... if someone deletes the contents of the cell, which is perfectly fine, the code throws a wobbly. It states there is a mismatch at that first If statement.

I have tried the following to trap it:

Please Login or Register  to view this content.

But checking this even deleting the box contents still returns false as an answer. I am going to presume as it has data validation in there (which is how the drop down is achieved.

Does anyone have any ideas on getting round this?

Many thanks.

[Norie]

Try using Target instead of Range(Target.Address) in the Intersect.

[malcmail]

I tried that but no difference - f course I then realised I had misled you. That is not the statement it fails on with the mismatch. It is the IF that is further down looking for the text "Repayment"

[Norie]

Does this work?

Please Login or Register  to view this content.