Standard PivotTable report selection format

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
 
I

ion

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top