how to get the column number in the pivot table

[bocode]

Hi All,

How do i get the cell address of a column label used in pivot table. Is there a way to get it thru pivotfields? I want to use the this solution in VBA.

Thank you
bocode

 

[Jerry Sullivan]

Hi bocode,

Yes, you can get to it through the PivotItem.LabelRange Property

Set rng = ActiveSheet.PivotTables("PivotTable1") _
        .PivotFields("Months").PivotItems("July").LabelRange
If Not rng Is Nothing Then
    MsgBox "Address is: " & rng.Address
End If