Standard PivotTable report selection format
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
ion wrote:
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
|