Thread: Pivot Table Select Range of Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pa32rt300t pa32rt300t is offline
external usenet poster
  
Posts: 1
Default 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]"
Reply With QuoteReply With Quote