Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I finally got it - for anyone who is having the same challenge. The code is
below: Sub PrintForms() Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem ' Set reference to pivot table Set pt = ActiveSheet.PivotTables(1) ' Set reference to the pivot field Set pf = pt.PivotFields("monid") For Each pi In pf.PivotItems Range("B1") = pi.Value ActiveSheet.PrintPreview 'ActiveSheet.PrintOut Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
How does one get the PivotTable report info that feeds another PivotTable report? | Excel Programming | |||
PivotTable - PivotTable Field name is not valid - error! | Excel Programming |