Read colums passed the filter in pivot table by using vba

Hello

I'm trying to get the number of items and its names showed in the first column(s) which pased the filter of my pivot table, here Pas1, Pas3, Pas5, Pas8 and Pas9 and the corresponding dates (mar 2017, ...):
pivottable.png

With Worksheets("Stock").PivotTables("PivotTable").PivotFields I could get access to the fields of source table but I how can I get access to created, processed pivot table.
How can I do that? Apreciate your answer!

First of all, I can't see your picture since PNG files don't show up in all browsers. Secondly, it would help a lot if you could post a sample spreadsheet. Third, posting the entire code would help.

However, it looks like you are almost there. You need to drill down one more level to the PivotItem. Loop through the pivot item and check for pi.visible = True to see what names are visible.

This is my go to source when I program pivot tables: http://peltiertech.com/referencing-p...ranges-in-vba/