Thread: Find first empty cell in column

Since you have tried a macro..try the below..If the first cell is not blank try the below.... Dim varFound As Variant Set varFound = Columns(1).Find("", LookIn:=xlValues, lookat:=xlWhole) MsgBox varFound.Address If this post helps click Yes --------------- Jacob Skaria "TomHull" wrote: > Hi, > > I need a formula that finds the first empty cell at the bottom of a column > of data....

Hi, I need a formula that finds the first empty cell at the bottom of a column of data. I have tried using the find and select function in a macro and it fails to find cells often. Have also tried using a MATCH formula but it doesnt seem to like finding an empty cell. Any Help, Thanks Tom

last nonblank Non-array, non-volatile formula for contents of last, non-blank cell in a range: =LOOKUP(2,1/(A1:A100<>""),A1:A100) For last non-blank text =LOOKUP(REPT("z",255),Sheet1!e1:e100,Sheet1!e1:e10 0) You can shorten that to: =LOOKUP(REPT("z",255),Sheet1!e1:e100) Last non-zero =LOOKUP(2,1/(B7:H7<>0),B7:H7) -- Bernard V Liengme Microsoft Excel MVP...