Identify Used Fields in a Pivot Table using VBA

[S Oberlander]

Is there any way to identify the names of the active pivot table fields or to check if a specific field is active?

I have two fields, one is "Fee rates" the other is "Fee rates with Description",
I need to be able to identify which one is in use for the macro to be able to execute properly.

 

[I_know_nuffin]

you can activate and the hide the fields using something like the below

    With ActiveSheet.PivotTables("PivotTable1").PivotFields("BreachYN")
    For x = 1 To .PivotItems.Count
    'Debug.Print .PivotItems(x).Name, .PivotItems(x).Value
     .PivotItems(x).Visible = True
    Next
    
        .PivotItems("(blank)").Visible = False
        .PivotItems("0").Visible = False
    End With

 

[S Oberlander]

that is just hiding and unhiding pivot fields
I don't want to touch that, I only have to know which fields are active to direct other parts of the macro