PivotTable.PivotSelect Method (Excel)
Selects part of a PivotTable report.
Syntax
expression .PivotSelect(Name, Mode, UseStandardName)
expression A variable that represents a PivotTable object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Name |
Required |
String |
The part of the PivotTable report to select. |
Mode |
Optional |
Specifies the structured selection mode. |
|
UseStandardName |
Optional |
Variant |
True for recorded macros that will play back in other locales. |
Remarks
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.
Example
This example selects all date labels in the first PivotTable report on worksheet one.
Worksheets(1).PivotTables(1).PivotSelect "date[All]", xlLabelOnly