adding rows to a table

Goodmorning,

I have a macro that adds a row to a table of names and account numbers. The code I have now is below:

Please Login or Register  to view this content.

This works fine, but when I run this macro multiple times it only inserts the new row at row 46. Is there a way to alter this code (or do it completely differently) so that everytime I run the macro it inserts the row at the end of the table (i.e. row 47, 48, etc)?

Thanks.

There may be a more sophisticated way but try this:

Please Login or Register  to view this content.

sportsranker,

please read forum rules below. Your code has being wrapped for you this time.

You could try

Please Login or Register  to view this content.

VAB Noob