XlTableStyleElementType enumeration (Excel)
Specifies the table style element used.
| Name | Value | Description |
|---|---|---|
| xlBlankRow | 19 | Blank row |
| xlColumnStripe1 | 7 | Column Stripe1 |
| xlColumnStripe2 | 8 | Column Stripe2 |
| xlColumnSubheading1 | 20 | Column Subheading1 |
| xlColumnSubheading2 | 21 | Column Subheading2 |
| xlColumnSubheading3 | 22 | Column Subheading3 |
| xlFirstColumn | 3 | First column |
| xlFirstHeaderCell | 9 | First header cell |
| xlFirstTotalCell | 11 | First total cell |
| xlGrandTotalColumn | 4 | Grand total column |
| xlGrandTotalRow | 2 | Grand total row |
| xlHeaderRow | 1 | Header row |
| xlLastColumn | 4 | Last column |
| xlLastHeaderCell | 10 | Last header cell |
| xlLastTotalCell | 12 | Last total cell |
| xlPageFieldLabels | 26 | Page field labels |
| xlPageFieldValues | 27 | Page field values |
| xlRowStripe1 | 5 | Row Stripe1 |
| xlRowStripe2 | 6 | Row Stripe2 |
| xlRowSubheading1 | 23 | Row Subheading1 |
| xlRowSubheading2 | 24 | Row Subheading2 |
| xlRowSubheading3 | 25 | Row Subheading3 |
| xlSlicerHoveredSelectedItemWithData | 33 | A selected item, hovered over by the user, that contains data. |
| xlSlicerHoveredSelectedItemWithNoData | 35 | A selected item, hovered over by the user, that does not contain data. |
| xlSlicerHoveredUnselectedItemWithData | 32 | An item, hovered over by the user, that is not selected and that contains data. |
| xlSlicerHoveredUnselectedItemWithNoData | 34 | A selected item, hovered over by the user, that is not selected and that does not contain data. |
| xlSlicerSelectedItemWithData | 30 | A selected item that contains data. |
| xlSlicerSelectedItemWithNoData | 31 | A selected item that does not contain data. |
| xlSlicerUnselectedItemWithData | 28 | An item that is not selected that contains data. |
| xlSlicerUnselectedItemWithNoData | 29 | An item that is not selected that does not contain data. |
| xlSubtotalColumn1 | 13 | Subtotal Column1 |
| xlSubtotalColumn2 | 14 | Subtotal Column2 |
| xlSubtotalColumn3 | 15 | Subtotal Column3 |
| xlSubtotalRow1 | 16 | Subtotal Row1 |
| xlSubtotalRow2 | 17 | Subtotal Row2 |
| xlSubtotalRow3 | 18 | Subtotal Row3 |
| xlTimelinePeriodLabels1 | 38 | Timeline Period Label |
| xlTimelinePeriodLabels2 | 39 | Additional Timeline Period Label |
| xlTimelineSelectedTimeBlock | 40 | Selected Timeline Time Block |
| xlTimelineSelectedTimeBlockSpace | 42 | Selected Timeline Time Block space |
| xlTimelineSelectionLabel | 36 | Timeline Selection Label |
| xlTimelineTimeLevel | 37 | Timeline Level |
| xlTimelineUnselectedTimeBlock | 41 | Unselected Timeline Time Block |
| xlTotalRow | 2 | Total Row |
| xlWholeTable | 0 | Whole Table |
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.