Printing from pivot tables:

I have created quite a complex pivot table using various database
queries, everything is
great except for printing reports. IS there a way that i acan automate
printing reports
ie. where the pivot table changes in length the macro will set the
pring area, scale to it to best
fit and then print. Basically the macro needs to recognise where the
bottom right hand corner if the data
is and set the print area for this data.
Another option that would be very useful is where the drop down menu
in the top right hand corner of the pivot table
is is it possibel to automate a print function where you can select to
print all these reports at once
instead of having to go into each one individually and then select
print

All help will be much apreciated

TP