"data" is a sample worksheet name where your table is and should be changed to your actual worksheet name.


Named Range:
ribbon, formulas, define name, define name (or ribbon, formulas, name manager, new)
name: tbl (or whatever you like)
scope: (up to you, workbook or...)
refers to: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))
($A$1 means range's (or table's) top left cell is A1)

by a dynamic range any added columns and rows are covered without havig to change the range in the code or formulas.



actually, if it is an xl Table, new rows and columns are added to the Table automatically.