Getting Pivot Table Hierarchy Using Excel VBA

[NeedForExcel]

Hi,

Is there a way for getting Pivot Table Hierarchy using Excel VBA?

For Example, in the attached image, the text marked in yellow is the Hierarchy which I am trying to extract. Similar to what GetPivotData would do when clicked on a cell on the Pivot Table.

Any guidance would be much appreciated.

[Olly]

Try:

Please Login or Register  to view this content.

[NeedForExcel]

Hi Olly,

Thank you for the reply. I have left office, I will check and revert tomorrow morning.

Thank you for your time..

Cheers!

[NeedForExcel]

HI,

I have tested your code, and it works in almost all cases. When you click on a Cell where there is no rating, just the currency, it returns only the currency.

I did manage to figure out the solution I was looking for by using the code below.

Please Login or Register  to view this content.

Thank you for the help.. Rep added & thread marked as solved.