Finding the last row with data and adding a record

[Ody]

I'd like to use a macro to update a table. I'm not sure how to do it? How do I find the last row in the table with data and add what I need to the row below it.

Any suggestions? Thanks!

 

[Smitty]

Cells(Rows.Count,"A").End(xlUp).Offset(1)

Will find the last used cell in column A and move down to the next empty cell.

HTH,