capture subtotals, slicer information from VBA?

[marvel]

in a pivot table i would like to capture the subtotal of a person based on if the the slicer name is the same as the column name

if the slicer name = column name then retrieve that subtotal of that person.....how can I go about achieving this in vba in a particular cell?

thanks.

 

[noboffinme]

Hi Marvel

Can you advise what you mean by 'slicer'?

Do you mean the 'Page' or 'Report' area value in the Pivot?