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