Test if cell is blank

[dflak]

I have a change event, and I want to test if the target cell is blank

MsgBox IsEmpty (Target) and MsgBox (Target.Value) always yield False.

Len(Target.Value) = 0 yields an error message.

Target.Value = "" yields an error message

Application.WorksheetFunction.IsBlank is not a valid function.

MsgBox target.value yields an error when the target is blank.


So there are 5 ways that do not work. Any ideas what might work?

Here is the pertinent part of the code. You can test it on Column B.

Please Login or Register  to view this content.

[dflak]

I found the problem. The target is a merged cell. So target.address is something like B12:H12. IsEmpty evaluates the whole range. So I amended the code:

Please Login or Register  to view this content.