PageFields in 'Rows to repeat at top'

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

How can I identify the addresses of PageFields so that I can set them
to print in the 'Rows to repeat at top' and the 'Columns to Repeat at
Left' in the Print setup?

My spreadsnheet has more than one Pivot Table with the Pvot Tbles
having different numbers of PageFields.

Thanks
 
For Each objPageField In PivotTable.PageFields
MsgBox objPageField.DataRange.Address
Next
 
Hi Frank

To set the row headers for a particular pivot table, try...
MsgBox ActiveSheet.PivotTables(1). _
PageRangeCells.EntireRow.Address

To set the column headers for a particular pivot table, try...
MsgBox ActiveSheet.PivotTables(1). _
RowRange.EntireColumn.Address


--
XL2002
Regards

William

(e-mail address removed)

| How can I identify the addresses of PageFields so that I can set them
| to print in the 'Rows to repeat at top' and the 'Columns to Repeat at
| Left' in the Print setup?
|
| My spreadsnheet has more than one Pivot Table with the Pvot Tbles
| having different numbers of PageFields.
|
| Thanks
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic PageField Items 2
Pivot Table PageField 4
Members in a PageField 1
Pivot Table: Optional Page Field 1
Pivot Pagefield multi-select? (Excel 2003) 8
EnableItemSelction on Page Field in 2003 VBA not working 4
Loop through PivotItems of PageField - including "(All)" 2
Pivot table 1

Back
Top