Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotItems for a Specific Filter
Hi,
In VBA I am trying to copy PivotItems and their corresponding values from a Pivot Table under multiple filters (top left corner). However, for some of these filters, some of the Pivot Items don't appear so I get an error when I try to copy them. Is there a way I can tell before I try to copy them whether they are present (i.e. have a non-zero value) under a specific filter? Thanks, Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter with a specific character | Excel Discussion (Misc queries) | |||
Determine if filter set on specific column | Excel Programming | |||
How do i total a specific sum, using the filter? | New Users to Excel | |||
Hide all PivotItems except for a specific Item | Excel Programming | |||
Add PivotItems to PivotTable / Enabling - Disabling PivotItems | Excel Programming |