Expand Minimize

XlPTSelectionMode Enumeration (Excel)

Specifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.

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

Show:
© 2014 Microsoft