Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
.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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |