Referring to ranges

Using 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, and False if not. The cell must truly be empty for the function to return True. If it contains even just a space that you cannot see, Excel does not consider the cell to be empty:


Say that 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 in column A, it colors in the first four cells of 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 You can make separations more obvious by using colored rows.