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.FieldsRow = 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.VisibleItemsRow = Row + 1
Cells(Row, 2) = Item.Name
Next
Thank you for your assistance
Bookmarks