Edit

XlTableStyleElementType enumeration (Excel)

  • Article

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.