Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Standard PivotTable report selection format
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Standard Chart from PivotTable ? | Charts and Charting in Excel | |||
PivotTable Report - NEW USER | Charts and Charting in Excel | |||
Report Filter in PivotTable | Excel Discussion (Misc queries) | |||
How does one get the PivotTable report info that feeds another PivotTable report? | Excel Programming | |||
Creating a PivotTable Report from an Another PivotTable Report | Excel Programming |