Re: PageFields in 'Rows to repeat at top'

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: William (willwest22_at_yahoo.com)
Date: 07/10/04

Next message: RossM: "Re: Fill series in visible cells only"
Previous message: count: "Scramble password a little bit"
In reply to: Frank_at_Rogers.com: "PageFields in 'Rows to repeat at top'"
Messages sorted by: [ date ] [ thread ]

Date: Sat, 10 Jul 2004 01:03:22 +0100

Hi Frank

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

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

-- 
XL2002
Regards
William
willwest22@yahoo.com
<Frank@Rogers.com> wrote in message
news:oq8ue0lh2dthd5saahna92eifgd1u5rh6d@4ax.com...
| 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
|

Next message: RossM: "Re: Fill series in visible cells only"
Previous message: count: "Scramble password a little bit"
In reply to: Frank_at_Rogers.com: "PageFields in 'Rows to repeat at top'"
Messages sorted by: [ date ] [ thread ]