Find first cell that displays nothing

[kod2th3e]

I have formulas in from cells B3 down through B1000 of a spreadsheet that will display "" (nothing) if they evaluate to false. There may be an instance where a particular cell within this column evaluates to false and I am trying to find and select the first cell that displays nothing using the following code:

Range("B3").End(xlDown).Offset(0, 0).Select

What ends up happening is cell B1001 gets selected even if say cell B651 is empty. I'm not sure what I'm doing wrong/what's missing so any all help anyone can provide would be much appreciated.

 

[jim may]

This works...

Sub Foo()


'Range("B3").End(xlDown).Offset(0, 0).Select


Set Rng = Range("B3:B1000")
For Each C In Rng
    If C = "" Then
        C.Select
    End If


Next C
End Sub

 

[hippiehacker]

With Range("b3:b1000")
Set gcell = .Cells.Find("")
End With

this would find the first empty cell in your range

 

[kod2th3e]

Perfecto! Thanks a ton Jim, I appreciate your help.

 

[jim may]

Glad it works for you. Thanks for reporting back.