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