Determine First non blank cell in col without Macro

Is there any way to use a worksheet function to determine the first non
blank row in a column? In a macro, I'd use something like this:

The_Row = Range("A1").End(xlDown).Row

Is there any worksheet function that can do this without a macro?

Hi Davenews,

Since you explicitly exclude a programmatic solution, would it not be more
appropriate, and more conducive to a successful resolution, to pose your
question in another group, such as Worksheet.Functions?


---
Regards,
Norman



"davenews" <dave711@bellsouth.net> wrote in message
news:zPdmf.26658$Pc3.1778@bignews5.bellsouth.net...
> Is there any way to use a worksheet function to determine the first non
> blank row in a column? In a macro, I'd use something like this:
>
> The_Row = Range("A1").End(xlDown).Row
>
> Is there any worksheet function that can do this without a macro?