What am I trying to achieve?

- In column A, I am looking for the row number of the last cell with an entry. So, if

A20 = "String" and
A21 = ""

it would return int = 20!

That's it.
As I said, first code works perfectly on the same sheet.

But that was for testing purposes only.
I need it to be running on another sheet (2nd code), but that does not work.

Thank you guys