Use VBA to put pivot table subtotal into a variable

Hi All

Does anyone know if it's possible to extract a pivot table subtotal with VBA?

I'd like to get the value 13 from the below table into a variable
i.e where 'RESULTS' field = 'TBC'

And it is possible, how would I handle errors if there are no TBC results in the pivot table?

Please Login or Register  to view this content.

Pivot Table - Bobs Jungle Gym.png

Any advice appreciated
All the best
Vicky

You can use Getpivotdata for that:

Please Login or Register  to view this content.

for example. Put an On Error Resume Next before it, and test the err.number if you want to know if the field isn't there.

Glad to help.