[RESOLVED] [Excel] Change Event Target.Value

[arcanine]

Hello,

I'm trying to determine if the changed cell on a worksheet is blank or not. I use the following code in the worksheet's Change event,

If Target.Value <> "" Then
    ...
End If

This works great, unless I use the delete key to clear a cell. When I do this, I get a Run-time error '13': Type mismatch. When I step through the code I added the following watch:

Target.Value

The type is shown as the following:

Variant/Variant(1 to 2, 1 to 1)

Does this mean the value is a two dimension variant array? Why? More importantly, how do I check for this, so my code doesn't break?