Cell is empty but IsEmpty is not working

Question

I am writing an IF statement that uses the IsEmpty function to determine if True or False. I tried it both on a cell with a value (e.g., PRB2039) and on a blank cell to test my code, and the result is the same.

I removed formatting, and tried it on a new worksheet. I don't know what I'm doing wrong.

will this help? `Evaluate("isblank(" & oRange.Address & ")")` — PatricK, Sep 30 '13 at 23:55

score 8 · Answer 1 · edited Oct 01 '13 at 04:54

8

I prefer using

If Len(Trim(Cells(i, 1).Value))=0 Then Msgbox "Empty"

edited Oct 01 '13 at 04:54

Santosh

12,175
4
41
72

answered Oct 01 '13 at 03:59

Siddharth Rout

147,039
17
206
250

I will try this one too. I'm a begginner. thanks, Siddharth Rout. – Cecilia Moneta Oct 01 '13 at 13:46

score 2 · Answer 2 · answered Oct 01 '13 at 01:16

2

As suggested by @PatricK you may consider using ISBLANK function instead of IsEmpty function. ISBLANK function Returns TRUE if the value is blank

enter image description here

Using VBA

Sub test()

    For i = 1 To 4
       MsgBox Evaluate("isblank(" & Cells(i, 1).Address & ")")
    Next

End Sub

answered Oct 01 '13 at 01:16

Santosh

12,175
4
41
72

I will try your suggestion, Santosh. Thank you. – Cecilia Moneta Oct 01 '13 at 13:45

Cell is empty but IsEmpty is not working

2 Answers2

Linked