Find last cell in active table

[stubbsj]

What code would I use to find the last cell in an active table? I need to find the last cell in the table, not the last cell in the worksheet.

I want to use a generic macro that can be used to add a row on any given spreadsheet tab. The macro is run when you press "Add Row" button on the spreadsheet. I need to find the last cell in the table, not the last cell in the worksheet.

Thanks in advance

[Ron Coderre]

This mini-macro selects the row immediately below a ListObject (Table):

Please Login or Register  to view this content.

Is that something you can work with?

[stubbsj]

Thanks Ron. I'll give it a try. What I really need is the last cell of the table.

[Ron Coderre]

OK...This macro selects the last table cell in the last row of the table:

Please Login or Register  to view this content.

Does that help?