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