determine empty row

[lezawang]

hi i am reading a code and part of it is to determine an empty row, please see below.
I could not understand it!! I tried to enter A1=10, A2=20, A3=30
I got 4. So row 4 is empty. So far so good. But when I did A1=10, A2=(empty), A3=30
I got 3 but row 3 is not empty. Is the code below makes any sense to you? Thank you


'Determine emptyRow
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1


https://www.excel-easy.com/vba/userform.html

 

[Fluff]

If you have values in A1 & A3 countA will give 2 (ie 2 values in the column) you then add 1 which gives 3.

If you are looking for the last used row +1 try

range("A"&rows.Count).End(xlUp).Offset(1).row