finding the last empty row - vba

[lezawang]

Hi
I understand to find the last empty row, I can use this line of code

 x = Cells(Rows.Count, 1).End(xlUp).Row

but now I just read an article and the following line is used to find the last row

 x = WorksheetFunction.CountA(Range("A:A")) + 1

I do not understand how the line above can find the last row! I understand countA() function is used to count how many cells in a range which has value (text/number). But I can not see how that function is used to find the last empty row. Any help would be very much appreciate. Thanks.

 

[Fluff]

I would advise against using the 2nd approach.
If you have blank cells in col A then the CountA method will give you the wrong row.