Print Area Pivot Table

  • Thread starter Thread starter Catherine
  • Start date Start date
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
 
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.
 
Back
Top