Print Area Pivot Table

[Catherine]

Hi,

I want to know how to setup my print area. The number of rows and column is
not fixed. My range is a Pivot Table.

Thanks,

Catherine

 

[Catherine]

Somedoby having an idea?

Thanks

Catherine

 

[Bob Umlas]

Pick one cell above the pivot table if it has a page area, or one cell
inside the pivot table, then your code can be
Selection.CurrentRegion.Name="'" & activesheet.name & "'!Print_Area"
then print.