Pivot Table - Selecting the GrandTotal Column in VBA xl2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All

can anyone help with the vba code for selecting either the GrandTotal Column
or Row in a pivot table. I seem to be able to select just about anything
else but these.
 
If you use the macro recorder while you manually select the totals, it
should create some sample code for you. For example:

ActiveSheet.PivotTables(1).PivotSelect _
"'Row Grand Total'", xlDataAndLabel, True

ActiveSheet.PivotTables(1).PivotSelect _
"'Column Grand Total'", xlDataAndLabel, True
 
Hi Debra

Thanks alot, i had tried it previously but it only showed as a selected
range.

Realised i didnt have the Enable Selection option selected.

Thanks for a such a quick reply.

Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table multiple filters 2
Unable to Group in Pivot Table 1
VBA Pivot Table Error 1
Playing back a Pivot Table macros 2
Using VBA on Excel Pivot Tables 3
Pivot table Grandtotal 2
Automatically Update a Pivot Table Field Used as Column / Row 1
How to calculate the sum of the columns in a row 2

Back
Top