TableStyleElements Object (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents table style elements.

Table styles define formatting for one or all of the elements of a table, PivotTable, or slicer. For example, a header row, last column, or total row are elements of a table and a table style can define that the fill color of the header row is blue, the last column is red.

A table style element in a table can have formatting specified in a table style applied to the element. XlTableStyleElementType enumeration contains the types of table style element that are available for use.