.CurrentPage = "(ALL)"

S

Steve8733

I have a PivotTable with a "Report Filter" named State. Whether I have ALL
selected or not the following equation is always true.

.PivotFields("State").CurrentPage = "(All)"

When I select one or multiple states selected .CurrentPage always equals
"(ALL)". I'm trying to use this in an IF statement to determine when ALL is
not selected.

I imagine I'm overlooking something. Any help would be greatly appreciated.
 
S

Steve8733

Correction. . . . .

If I select an individual item .CurrentPage equals the individual item
selected. The problem is when multiple items are selected, .CurrentPage still
returns "(ALL)" as a value even thought ALL is not selected.
 

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

Newbie code not working 1
Pivot Tables in VBA: Problem with AddFields Method 2
Pivot Multi Page Diff Change 2
delete selection in pivotcolumn 3
Pivot Table Filtering - Macro 3
Change a pivot field based on another pivot field 10
VBA Guru's - any way to speed up this code? 1
Change Page Field in a Pivot Table and Print Chart + Data 2

Top