Pivot Table - Selecting the GrandTotal Column in VBA xl2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dgrant_jr - 25 Jan 2007 14:51 GMT

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.

Signature

dgrant_jr@nospam_hotmail.com

Reply to this Message

Debra Dalgleish - 25 Jan 2007 15:07 GMT

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

> 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.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

dgrant_jr - 25 Jan 2007 15:20 GMT

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

Signature

dgrant_jr@nospam_hotmail.com

> If you use the macro recorder while you manually select the totals, it
> should create some sample code for you. For example:
[quoted text clipped - 8 lines]
> > or Row in a pivot table. I seem to be able to select just about anything
> > else but these.

Reply to this Message

Debra Dalgleish - 25 Jan 2007 15:42 GMT

You're welcome, and thanks for describing how you fixed the problem.

> Hi Debra
>
[quoted text clipped - 6 lines]
>
> Dennis

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message