how to detect the ending row?

I intend to detect which row is the last row that are filled with data, and I want to write data into a new row that immediately follows the last row. How can I do that?

Thanks a lot!