ExcelBanter - Pivot Table Select Range of Value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Pivot Table Select Range of Value (https://www.excelbanter.com/excel-programming/325387-pivot-table-select-range-value.html)

pa32rt300t

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]"

All times are GMT +1. The time now is 08:59 AM.