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