ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PivotItems for a Specific Filter (https://www.excelbanter.com/excel-programming/426614-pivotitems-specific-filter.html)

charles

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


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com