TableObject.RefreshStyle (Excel)

Returns or sets the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a record set returned by a query. Possible return values are xlInsertDeleteCells - Partial rows are inserted or deleted to match the exact number of rows required for the new recordset, xlInsertEntireRows - Entire rows are inserted, if necessary, to accommodate any overflow. No cells or rows are deleted from the worksheet, xlOverwriteCells - No new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow.

ActiveCell.ListObject.TableObject.RefreshStyle = xlInsertDeleteCells