Printing only "Used Data" in a Pivot Table

[Henry]

Good Morning:

I'm look for assistance in printing a PTs Used Range.

When the first customer selects their PT scenario, I'd like for them to just hit a Button and only the "Used Area" prints, except for the top 5/6 Rows.

When the next customer modifies the PT (more Rows/Columns), I'd like for them to Print their "new" view of the PT. Is there something out there that will alleviate the customer form having to Set Print Area and just hit a Button that says "Print?"

Thanks!!!!!!!!!

 

[Juan Pablo González]

You could use the .TableRange1 or .TableRange2 properties of the PivotTable to return the Address and assign them to the Print Area.