weird problem with PivotFields CurrentPage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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! =)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing the CurrentPage items in a Pivot Table 1
Using macro to switch 'page' in a pivot table? 1
Format Pivot total rows 2
Pivot Tables in VBA: Problem with AddFields Method 2
Update Pivot Table Filters based on a Cell Value in Excel 2007 0
Selecting todays date 3
pivot table macro with a filtering variable 3
VBA Pivot Table Error 1

Back
Top