Print Area Pivot Table
 

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

Print Area Pivot Table
 

Somedoby having an idea?

Thanks

Catherine

"Catherine" wrote:

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

Print Area Pivot Table
 

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.


"Catherine" wrote in message
...
Somedoby having an idea?

Thanks

Catherine

"Catherine" wrote:

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