PivotTable.PivotSelect (Excel)

Selects part of a PivotTable report.

You can use the specified mode only to select the corresponding item in the PivotTable report. For example, you cannot select data and labels by using xlButton mode; likewise, you cannot select buttons by using xlDataOnly mode.

PivotSelect (Name, Mode, UseStandardName)


Worksheets(1).PivotTables(1).PivotSelect "date[All]", xlLabelOnly

Arguments

The following argument is required

Name (String) - The part of the PivotTable report to select.

Optional arguments

The following arguments are optional

Mode (XlPTSelectionMode) - Specifies the structured selection mode.


Possible values are

xlBlanks Blanks
xlButton Buttons
xlDataAndLabel Data and labels
xlDataOnly Data
xlFirstRow First row
xlLabelOnly Label
xlOrigin Origin

UseStandardName (Boolean) - True for recorded macros that will play back in other locales.