Quote Originally Posted by Jan Karel Pieterse View Post
I expect VBA generates your table, correct? In that case you should be able to know the size of the table during that process and you can assign a range name to the newly inserted table rows.
Suppose you have a range object called oRng:
oRng.Name = "TheTable"

Yes Vba generates my table but I have a table in multiple sheets (22 Sheets) And table range varies in each sheet. So I am looking to code for a single table and loop it through all sheets.

(P.S. all the tables start in same cell (say A1) but varies in rows and columns. Its ok if the code do not take care of columns, i can make number of columns same for all table)