Help Understanding a Snippet of Code

[reberryjr]

I was recently trying to code for a pivot table to collapse some row fields, and ran into the underlying code. It works, but I don't really understand it. I will likely have to build more code with pivot tables, so I'm hoping someone can help me understand this snippet...specifically how PF.Name collapses all of the row fields to the first one. I would've assumed that I would have to actually enter the row field I wanted the table collapsed to.

With PT
    For Each PF In PT.RowFields
        PF.DrillTo PF.Name
    Next PF
End With

 

[Wookiee]

i am also not that familiar with pivot tables and their coding, but this code made sense after i looked up the method being applied to the pivot field.

assuming that PT is a PivotTable type and PF is a PivotField, when you use the .DrillTo method, it collapses that field's section in the pivot table (like the way you can collapse fields on a subtotaled list).

PivotField.DrillTo method (Excel)

Office VBA reference topic

learn.microsoft.com

 

[reberryjr]

i am also not that familiar with pivot tables and their coding, but this code made sense after i looked up the method being applied to the pivot field.

assuming that PT is a PivotTable type and PF is a PivotField, when you use the .DrillTo method, it collapses that field's section in the pivot table (like the way you can collapse fields on a subtotaled list).

PivotField.DrillTo method (Excel)

Office VBA reference topic

learn.microsoft.com

Right...I think the .Name portion is throwing me off.