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!

Please Login or Register  to view this content.

is the cell below the last filled cell of column A.

Please Login or Register  to view this content.

is the first row (number) below the used range.

This helps!

Originally Posted by VBA Noob

These links may also be useful

http://www.rondebruin.nl/last.htm

http://www.ozgrid.com/VBA/ExcelRanges.htm

VBA Noob

This works for me.

Originally Posted by mikerickson

Please Login or Register  to view this content.

is the cell below the last filled cell of column A.

Please Login or Register  to view this content.

is the first row (number) below the used range.