| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotTable.PivotSelect method (Excel) |
vbaxl10.chm235137 |
|
|
e9beda74-c022-3ba7-b3af-d607024846f2 |
05/09/2019 |
medium |
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. |
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.
Worksheets(1).PivotTables(1).PivotSelect "date[All]", xlLabelOnly[!includeSupport and feedback]