| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting a pivot table through VBA
Hi Valeria,
A couple of suggestions : 1. To delete Totals, there is no need to delete, it can be part of Table Options With ActiveSheet.PivotTables("PivotTable1") .ColumnGrand = False .RowGrand = False End With 2. The xlLastCell instruction can be tricky, it might be safer to use Range(Selection, Selection.End(xlDown)).Select HTH Cheers Carim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting Pivot Table Raw Data | Excel Worksheet Functions | |||
| How I can create a Pivot table by selecting two Different Pivot | Excel Worksheet Functions | |||
| Help with Selecting Ranges in Pivot Table | Excel Programming | |||
| Pivot Table Selecting Items | Excel Programming | |||
| Selecting Rows in Pivot Table | Excel Programming | |||
Threaded Mode
