VBA to set Pivot Table formats

[David]

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

 

[Patrick Molloy]

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