Count from/until blank not working

[tourless]

Hi Folks.

Starting in cell I3 I'm simply trying to count the cells with values until I reach the first blank cell. But for some reason it returns the count from I1 to the first blank cell. I have no idea why...

nDays = Range("I3").End(xlDown).Row

 

[tourless]

You're welcome & thanks for the feedback.

In the end, I'm using the best of both worlds. Thank you all.

If Range("I4") = "" Then
        nDays = 1
    Else
        nDays = Range("I3", [i3].End(xlDown)).Count
    End If