Zero Value = Non Blank

[ToddG]

I'm trying to select the first blank cell in a column with VBA, but I'd like to treat zero values as non blank. Is there a way to do this?

 

[Andrew Poulsom]

Zero values aren't blank.

 

[mikerickson]

With Range("A:A")
    .Find(vbNullString, after:=.Cells(.Rows.Count, 1), LookIn:=xlValues, lookat:=xlWhole, searchdirection:=xlNext).Select
End With

 

[ToddG]

Thanks very much to you both. That got me in the right direction.