View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
charles charles is offline
external usenet poster
 
Posts: 124
Default 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