.CurrentPage = "(ALL)"
 

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.

.CurrentPage = "(ALL)"
 

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.

"Steve8733" wrote:

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.