Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables: Alternative to PivotSelect?
Hi guys
In VBA, we're accustomed to referencing ranges rather than selecting them (which is of course what the macro recorder does). However, when referencing ranges within a PivotTable, I don't seem to be able to avoid PivotSelect and am wondering if there is one. For example, in the following code, I am trying to format the total columns of a ColumnField (pt is a declared PivotTable) pt.PivotSelect "CategoryDemand[All;Total]", xlDataAndLabel, True Selection.Interior.ColorIndex = 43 Selection.Font.Bold = True So my question is, can I reference this range and format it, avoiding PivotSelect? Thanks in advance Paul Martin Melbourne, Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
(Tom?) Pivot tables, code to refer to all pivot tables on template | Excel Programming | |||
pivot tables: pivotselect with a very large table | Excel Programming | |||
PivotSelect | Excel Programming | |||
Pivot tables-controlling user interaction with pivot tables | Excel Programming |