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
|