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
 

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

Similar Threads

Pivottable Pivotselect string 2
PivotTables Refresh not work 1
Pivot Table Macro Help 1
Problem with Macro in MAC 3
Ghost excel process 1
Pivottable refresh problem 1
Trying to clean up code that I did through a record macro 1
Dynamic PivotTable source - limit sources 1

Back
Top