none
Pivot Table VisibleItemsList not working RRS feed

  • Question

  • Hi -- I am trying to set the filters for one pivot table based on another pivot table. However, when i am trying to get the visibleitemslist in the first pivot table into an array i am getting blank i.e. ""

    Following is the code i am using:

    Ary = Sheets("Sheet1").PivotTables("PivotTable1").PivotFields("[Time].[Year].[Year]").VisibleItemsList

    Regards

    Krish

    Tuesday, November 22, 2011 7:17 PM

Answers