XlPTSelectionMode Enumeration
Specifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.
Version Information
Version Added: Excel 2007
| Name | Value | Description |
|---|---|---|
| xlBlanks | 4 | Blanks |
| xlButton | 15 | Buttons |
| xlDataAndLabel | 0 | Data and labels |
| xlDataOnly | 2 | Data |
| xlFirstRow | 256 | First row |
| xlLabelOnly | 1 | Label |
| xlOrigin | 3 | Origin |