View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chrysalis Chrysalis is offline
external usenet poster
 
Posts: 1
Default weird problem with PivotFields CurrentPage

i wonder why setting CurrentPage property does not work for me. For example, in the active sheet, there is a pivot table called "PivotTable1", with [Customers] as PageField, and some other dimensions and measures. Setting the following statement, returns me an error of "Unable to get CurrentPage property of PivotField class"

ActiveSheet.PivotTables("PivotTable1").PivotFields ("[Customers]").CurrentPage = "(All)

Did i miss anything? should i set something before setting the CurrentPage property? it's weird, how come you all post the examples using the same/similiar statement works for you all but not me?!!

FYI, i am using Excel 2002... Thanks for ya help! =)