PivotTable.PivotSelect Method

Excel Developer Reference

Selects part of a PivotTable report.


expression.PivotSelect(Name, Mode, UseStandardName)

expression   A variable that represents a PivotTable object.


Name Required/Optional Data Type Description
Name Required String The part of the PivotTable report to select.
Mode Optional XlPTSelectionMode Specifies the structured selection mode.
UseStandardName Optional Variant True for recorded macros that will play back in other locales.


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.


This example selects all date labels in the first PivotTable report on worksheet one.

Visual Basic for Applications
  Worksheets(1).PivotTables(1).PivotSelect "date[All]", xlLabelOnly

See Also