Cell is empty but IsEmpty is not working

excel vba is-empty
Cecilia Moneta picture Cecilia Moneta · Oct 1, 2013 · Viewed 14.4k times · Source

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.

Answer

Siddharth Rout picture Siddharth Rout · Oct 1, 2013

I prefer using

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

Related questions

How to check if a date cell in Excel is empty?

If feels like this should be really easy but I dont get it to work without retrieving the value of the cell again. To start with, I have 2 date cells: Dim agreedDate As Date Dim completedDate As Date THIS WORKS .. (…

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
How do I declare a global variable in VBA?

I wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And I get the error message: "invalid attribute in Sub or Function" Do you know what I did wrong? I tried …

Read More