Use vba to get detail from pivot table selection

[ola7mat]

Hello,

I am not sure what this is called if it has a name, but I am trying to get the detail from a pivot table based on the cell that is selected.
The kind of info that is shown when you hover the cursor over a pivot table value.

Capture.JPG

In yellow on the attachment shows what i am after.

Does anybody know how to reference this in vba?

Thanks
Matt

[Olly]

All that information is properties of the PivotCell object, of the Range. So you could access it something like:

Please Login or Register  to view this content.

[ola7mat]

thank you helped me get exactly what i needed!