I cannot figure out how to make this count right. I'm looking for a count of true blank cells. Here is the code.
Code
For i = 2 To lastRow
If IsEmpty(lotusRawData.Cells(i, 5)) = True Then
If lotusRawData.Cells(i, 5).Value <> 0 Then
x = x + 1
End If
End If
Next i
I know the count should be 57 but it's returning 2212 because it's also including the 0's.