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