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" wrote in message
.. .
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?