Standard PivotTable report selection format

  • Thread starter Thread starter ion
  • Start date Start date
I

ion

So, the help file for PivotSelect says...
expression.PivotSelect(Name, Mode, UseStandardName)
Name Required String. The selection, in standard PivotTable report
selection format.

Does anyone have an idea what standard PivotTable report selection
format is? It apparently involves brackets. This is the example:

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

Worksheets(1).PivotTables(1).PivotSelect "date[All]", xlLabelOnly
 
It also involves single quotes. To hide a summation column named 'total
pending', I had to
Set rng = Selection
pt.PivotSelect "'Total Pending'", xlDataAndLabel, True
Selection.EntireColumn.Hidden = True
rng.Select 'restore the selection
 
Back
Top