Printing Pivot Tables

I have an issue with printing a worksheet with a pivot table. When refreshing the table, depending on the filter choices, the table length with expand and contract. When the pivot table contracts, it leaves a light blue shaded area. If you try to print the worksheet it includes the blue section. Is there a print macro that can be written that will only print the sections with values or perhaps a print setting that would exclude the shaded area?

http://www.myonlinetraininghub.com/e...mic-print-area

This method worked for me some time ago. Good luck.

Pete