Find & select 1st blank cell in a range of formulated column cells

I think this should work. I tried it on a sample and it selects the first cell with a blank value even if there is a formula in that cell.

Private Sub Worksheet_Activate()
For Each cell In Range("e9:e48")
    If cell.Value = "" Then
        cell.Select
        Exit Sub
    Else
    End If
Next
End Sub