Good Morning,

Could someone please tell me how to List the items in the Pivot Table Report Filter

I have tried this

Set Table = Worksheets("Pivot").PivotTables(1)
For Each Field in Table.Fields
Row = Row + 1 Cells(Row, 1) = Field.Name For Each Item in Field.PivotItems
Row = Row + 1 Cells(Row, 2) = Item.Name
Next
Next
This lists all the fields and items in the Column Labels, Row Labels and Values, but not the Report Filter

I thought that it might have something to do with either VisibleItems or VisibleItemsList, but the following does not work

For Each Item in Field.VisibleItems
Row = Row + 1 Cells(Row, 2) = Item.Name
Next
Thank you for your assistance