Thread: program excel worksheet to automatically not print blank rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default program excel worksheet to automatically not print blank rows
Take a look at Ron de Bruin's site
http://www.rondebruin.nl/print.htm
in particualr scroll down to the section
Hide Rows or Cells when you print a sheet
and insert the section Hide rows with a blank cell in column A

--
Regards
Roger Govier
wrote in message
oups.com...
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



Reply With QuoteReply With Quote