run-time error '13' Type Mismatch error

[bdouglas1011]

I have code that prevents the user from choosing a duplicate choice from a list - everything works pretty much the way it should, but if the user Deletes or clears content in that range I get a run-time error '13' Type Mismatch error.

What can be added to not have this happen? When I debug it point to

Please Login or Register  to view this content.

The complete Code is:

Please Login or Register  to view this content.

[TMS]

Maybe:

Please Login or Register  to view this content.

[TMS]

Thanks for the rep

The first line eliminates multiple cell selection, which would be typical if a whole row, or whole column, or a block of cells were selected for deletion. And the second ignores changes where the content of the target cell has been deleted .


Regards, TMS