VBA to set Pivot Table formats
 

I intend to re-set formats using the worksheet open event
My question is about referencing cells within the pivot table with the VBA
code
For example, if I want to work on the format of the table column headers
will there be a reference like: MyPivotTable.rows(1) that I can use?
Thanks - any advice will be appreciated

VBA to set Pivot Table formats
 

not with 2003

try this though ....

Dim pt As PivotTable
Dim topRow As Range
Set pt = ActiveSheet.PivotTables(1)
Set topRow = pt.TableRange1.Rows(1)
topRow.Select

"David" wrote:

I intend to re-set formats using the worksheet open event
My question is about referencing cells within the pivot table with the VBA
code
For example, if I want to work on the format of the table column headers
will there be a reference like: MyPivotTable.rows(1) that I can use?
Thanks - any advice will be appreciated