Using the ISEMPTY Function to Check Whether a Cell Is Empty : IsEmpty « Data Type Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type Functions
  3. IsEmpty

Using the ISEMPTY Function to Check Whether a Cell Is Empty

 
Sub isemptyDemo()
    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
End Sub








Related examples in the same category

1.Working with Empty and Null
2.Test a Variant variable to see whether it has the Empty value