Thread
:
program excel worksheet to automatically not print blank rows
View Single Post
#
3
Debra Dalgleish
Posts: n/a
Unless you have other data on the sheet, you shouldn't need a print
area. Clear it, then the pages to print will adjust as the pivot table
changes size.
wrote:
I have an excel spreadsheet where a pivot table is automatically
generated that varies in length. I don't want to resize the print area
each time. Is there a macro that anyone can share that instructs excel
not to print blank rows?
Thanks
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Reply With Quote