Excel VBA IsBlank Function? (No, Use IsEmpty)

VBA & macros · Updated November 22, 2026

Excel VBA does not have a built-in IsBlank function. The function you are looking for is IsEmpty, which checks whether a variable or a cell has been initialized or contains an empty value. For worksheet cells, you typically use IsEmpty(Range(...)) to test if a cell is truly blank (no value, no formula, no formatting).

Why People Search for IsBlank in VBA

In Excel’s worksheet formulas, ISBLANK() is a real function that returns TRUE if a referenced cell is empty. When users move to VBA, they often try to call WorksheetFunction.IsBlank or simply type IsBlank in code, only to get a compile error. The confusion arises because VBA has its own set of built-in functions that differ from worksheet functions. VBA’s IsEmpty serves a similar purpose but works differently under the hood.

How IsEmpty Works in VBA

IsEmpty returns a Boolean (True or False) indicating whether a variable has been initialized. For an object variable (like a Range), it returns True if the variable is set to Nothing. For a cell, you pass the cell’s value to IsEmpty. The syntax is:

IsEmpty(expression)

Where expression can be a variable or a cell reference like Range("A1").Value. If the cell is truly empty (no value, no formula, no leading apostrophe), IsEmpty returns True. If the cell contains a zero-length string ("") from a formula, IsEmpty returns False because the cell has a value (even though it looks blank).

Practical Example: Checking a Cell

Here is a simple macro that checks if cell A1 is blank and displays a message:

Sub CheckBlankCell()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets("Sheet1")
    
    ' Save a copy before running any macro
    If IsEmpty(ws.Range("A1").Value) Then
        MsgBox "Cell A1 is blank."
    Else
        MsgBox "Cell A1 has content."
    End If
End Sub

Note that IsEmpty checks the value property. If A1 contains a formula that returns "", the cell is not considered empty by IsEmpty. To treat formula blanks as blank, you need a different check, as shown later.

Alternatives: Len, Trim, and WorksheetFunction

Depending on what you mean by “blank,” you might need a different approach:

  • Len(Trim(Range("A1").Value)) = 0 – returns True if the cell has no characters (ignores spaces). This treats "" and " " as blank.
  • WorksheetFunction.CountBlank(Range("A1")) – returns 1 if the cell is blank, but this counts cells with formulas that return "" as blank (similar to the worksheet ISBLANK function).
  • Range("A1") Is Nothing – checks if a range object variable is unset, not if the cell is empty.

For most cases, IsEmpty is the fastest and most direct method, but it does not consider spaces or formula blanks as empty.

Common Problems and Misconceptions

A frequent mistake is using IsEmpty on a Range object directly, like IsEmpty(Range("A1")). This often returns False even if the cell is blank because the Range object itself is not empty – it exists. You must use .Value or .Value2. Another issue is that IsEmpty returns True for a variable that has been declared but not assigned, but it returns False for a variable set to 0 or "". So if you are checking a cell that contains a formula returning 0, IsEmpty will return False, which is correct because the cell has a value.

How to Choose the Right Blank Check

Choose your method based on what you need:

  1. Use IsEmpty when you want to know if a cell has never been touched (no value, no formula). This is the fastest check.
  2. Use Len(Trim(...)) = 0 when you want to treat cells with spaces or empty strings as blank (e.g., user input that might have accidental spaces).
  3. Use WorksheetFunction.CountBlank when you need to match the behavior of the worksheet ISBLANK function, which counts formula blanks as blank.

For example, if you are looping through a column of user-entered data, you might want to stop at the first truly empty cell. IsEmpty is ideal. If you are cleaning data where some cells contain spaces, Len(Trim(...)) is better.

Frequently Asked Questions

Can I use WorksheetFunction.IsBlank in VBA?

Yes, you can call WorksheetFunction.IsBlank in VBA, but it works like the worksheet function: it returns True only if the cell is truly empty (no value, no formula). It does not treat spaces as blank. However, it is slower than IsEmpty and requires the cell reference, not just the value. For example: If WorksheetFunction.IsBlank(Range("A1")) Then. But for most VBA code, IsEmpty is more efficient and idiomatic.

Why does IsEmpty return False for a cell with a formula that returns “”?

Because the cell has a value – a zero-length string. IsEmpty only returns True when the cell has no value at all. A formula that returns "" is considered a value, even though it looks blank. If you want to treat that as blank, use Len(Trim(...)) = 0 or WorksheetFunction.CountBlank.

How do I check if a range is entirely blank in VBA?

You can use WorksheetFunction.CountBlank and compare it to the total number of cells in the range. For example, if your range is A1:C10 (30 cells), you can check if WorksheetFunction.CountBlank(Range("A1:C10")) = 30. Alternatively, you can loop through each cell and use IsEmpty on each, but that is slower for large ranges.

Is there a difference between IsEmpty and Len(Trim(…)) = 0?

Yes. IsEmpty returns True only if the cell has no value at all. Len(Trim(...)) = 0 returns True if the cell has no characters after removing spaces, so it treats "" and " " as blank. The latter is more forgiving for user input that might contain accidental spaces.

Does IsEmpty work on a cell that contains a formula that returns an error?

No. If a cell contains a formula that returns an error like #N/A, IsEmpty returns False because the cell has a value (the error). To check for errors, use IsError or WorksheetFunction.IsError.

Final Thoughts

While there is no IsBlank in VBA, IsEmpty is the closest built-in function and covers most needs. Remember to always use .Value when checking a cell, and choose the alternative method if you need to handle spaces or formula blanks. Save a copy of your workbook before running any macro, as macros cannot be undone with Ctrl+Z. Now you can confidently check blanks in VBA without the compile error.

Related

Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.

More in VBA & macros

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.