Print Area Pivot Table

C

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
 
B

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.
 
Top