>I've got this Pivot Table with one pagefield. I want to print out each item in that page field. How do I access those values thur a macro and/or find out how many there are?
>
>TIA
>Jeff

    Dim rgLast As Range
    Set rgLast = Range("A1").SpecialCells(xlCellTypeLastCell)       ' Get the last col & Row
    Dim iLRow As Long, iLCol As Long
    iLRow = rgLast.row                                              ' assign the last row
    iLCow = rglast.Column                                           ' assign the last col

After this you will be able to reference the values like any other sheet by looping through your desired range.