I need a script to drill into a pivot table

[lwelch1980]

Hi,
I am new to VBA and I am trying to run a routine that selects the grand total in a pivot table. When I try to record the Macro, I can select a cell (like h9) but not the grand total of a specific table.

 

[cSciFiChick]

So once you select the grand total what are you doing with it? Are you trying to reference to it from another tab? Are you copying and pasting it somewhere? Normally to reference data in a pivot table you can use formula =GETPIVOTDATA("Name of Field",$A$4). Can you provide some more detail on what you are wanting to do.

Thanks