Home > Articles > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Use the ISEMPTY Function to Check Whether a Cell Is Empty

The ISEMPTY function returns a Boolean value that indicates whether a single cell is empty: True if empty, False if not. The cell must truly be empty for the function to return True. Even if it has a space that you cannot see, Excel does not consider the cell to be empty:

IsEmpty(Cell)

You have several groups of data separated by a blank row. You want to make the separations a little more obvious. The following code goes down the data in Column A. When it finds an empty cell, it colors in the first four cells for that row (see Figure 3.4):

LastRow = Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To LastRow
    If IsEmpty(Cells(i, 1)) Then
        Cells(i, 1).Resize(1, 4).Interior.ColorIndex = 1
    End If
Next i
Figure 3.4

Figure 3.4. Colored rows separating data.

  • + Share This
  • 🔖 Save To Your Account