If you set the worksheet to print to one page (FilePage Setup, Page
tab), it should automatically adjust to fit the entire pivot table, no
matter how it's arranged.

Grant wrote:
I need to be able to print a pivot table, but I need the selection that it prints to update depending on the size of the pivot table. Creating a macro that selects the pivot table first then prints it, prints it out as two pages, one for the pages, the second for the data.

Any help?

Thanks,
Grant.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html