Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - Selecting the GrandTotal Column in VBA xl2003
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - Selecting the GrandTotal Column in VBA xl2003
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 dgrant_jr wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - Selecting the GrandTotal Column in VBA xl2003
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 -- "Debra Dalgleish" wrote: 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 dgrant_jr wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - Selecting the GrandTotal Column in VBA xl2003
You're welcome, and thanks for describing how you fixed the problem.
dgrant_jr wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Column Totals - XL2003 | Excel Discussion (Misc queries) | |||
How I can create a Pivot table by selecting two Different Pivot | Excel Worksheet Functions | |||
Selecting Fields in Pivot Table | Excel Discussion (Misc queries) | |||
selecting a pivot table through VBA | Excel Programming | |||
Filter PIVOT table in XL2003 | Excel Discussion (Misc queries) |