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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables: Alternative to PivotSelect?
I'm still looking for an answer, even if it's "no, you can't do it".
On Oct 8, 12:13*pm, Paul Martin wrote: 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 |
Reply |
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 |