Printing only "Used Data" in a Pivot Table

Henry · Mar 19th, 2002, 08:40 AM

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 · Mar 19th, 2002, 09:40 PM

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

Mar 19th, 2002, 09:40 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	You could use the .TableRange1 or .TableRange2 properties of the PivotTable to return the Address and assign them to the Print Area. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 08:40 AM	#1
Henry Board Regular Join Date: Mar 2002 Location: Mike T. Posts: 180	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!!!!!!!!!