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 |