C
Chrysalis
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! =)
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! =)