Class TableObject (Excel VBA)

The class TableObject represents a worksheet table built from data returned from a PowerPivot model.

The main procedure of class TableObject is Delete


To use a TableObject class variable it first needs to be instantiated, for example

Dim tot as TableObject
Set tot = ActiveCell.ListObject.TableObject

TableObject class variables can be set using the ListObject.TableObject procedure.


Some procedures in this class have been grouped together in themes and are described on separate theme pages

Enable with its procedures EnableEditing and EnableRefresh
Row with its procedures FetchedRowOverflow and RowNumbers


This is the main method of the TableObject class

Delete - Deletes the TableObject object.


Other Methods

Refresh - This method updates the TableObject object.


AdjustColumnWidth specifies if the column widths are automatically adjusted for the best fit each time you refresh the specified query table. The default value is True.

Destination returns the cell in the upper-left corner of the query table destination range (the range where the resulting query table will be placed). The destination range must be on the worksheet that contains the TableObject object.

ListObject returns a ListObject object for the TableObject object.

Parent returns an object that represents the parent object of the specified Tableobject object. Read-only.

PreserveColumnInfo specifies if column sorting, filtering, and layout information is preserved whenever a query table is refreshed. The default value is False.

PreserveFormatting true if any formatting common to the first five rows of data are applied to new rows of data in the query table. Unused cells aren't formatted. The property is False if the last AutoFormat applied to the query table is applied to new rows of data. The default value is True.

RefreshStyle 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.

ResultRange returns a Range object that represents the area of the worksheet occupied by the specified query table.

WorkbookConnection returns the WorkbookConnection object used by the TableObject for connecting to the model.