Worksheet_Change - Cell States (Numeric, Chars, Blank) not hitting conditions?

[K26]

Hello (First Post - Go Easy!)

Having an issue with a Worksheet_Change Event where I'm trying to distinguish what type of action a user has performed within a Column Cell Range. I need to work out if the user has entered a numeric value, characters or whether they have deleted the cell. I cannot work out why with my current solution I can hit the first and last condition but not the second?

I've tried multiple variants of the second condition using solutions like cell value = "", cell value = vbNullString and a few others.

Please Login or Register  to view this content.

Cheers!

[davesexcel]

Try

Please Login or Register  to view this content.

[K26]

Works perfectly! Never thought about checking the Target Object its self. Thank you