Return Last Empty Row in a TextLabel - Userform

[Karmadyl]

Good day,

My question is quite simple : I am trying to return the last empty row from a table (Line number where the data will be inserted) into a Text Label that will show on my UserForm. I've looked around and I couldn't stubble upon anything relevant.

Thanks,

 

[James006]

Hello,

Not sure to fully understand your question ...

If within a given range, you need the Row number of the last empty row ...

you could test following :

=SUMPRODUCT(MAX((ROW(A1:A20))*(A1:A20="")))

Hope this will help

 

[DanteAmor]

Put the follwing in your userform

Private Sub UserForm_Activate()
    Label1 = " last empty row : " & Range("A" & Rows.Count).End(xlUp).Offset(1).Row
End Sub

 

[James006]

Hope there is no confusion between the Last Empty Row ... and the Last Empty Row within a predetermined range ...

 

[DanteAmor]

I do not think so

 

[James006]

... I've looked around and I couldn't stubble upon anything relevant ....

Let the OP decide ...

 

[DanteAmor]

Then we should not speculate about confusions, let's wait for the test and then ...

 

[Karmadyl]

Put the follwing in your userform

Private Sub UserForm_Activate()
    Label1 = " last empty row : " & Range("A" & Rows.Count).End(xlUp).Offset(1).Row
End Sub

Good day,

Exactly what I was looking for!

Best regards,

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.