| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Select Range of Value
The below code will selct the bottom value in a pivot table. Does anyone
know how to select a range of values say from score = 50 and score <=70? ActiveSheet.PivotTables("PivotTable2").PivotFields ("[Store].[Store]").AutoShow _ xlAutomatic, xlBottom, 1, "[Measures].[Score]" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a coloumn or row in a Pivot table | Excel Discussion (Misc queries) | |||
| AUTO SELECT A RANGE FOR PIVOT TABLE | New Users to Excel | |||
| Using cursor keys to select Pivot Table Source Data Range | Excel Discussion (Misc queries) | |||
| Select Pivot Table | Excel Discussion (Misc queries) | |||
| How to select range of values in pivot table? | Excel Programming | |||
Threaded Mode
