MrExcel Publishing
Your One Stop for Excel Tips & Solutions

conditional hide/skip rows

Posted by ryanB on December 18, 2001 8:35 AM

I have a worksheet that prints employee statements. Not all amployees have the same line items, thus, when using a standard template to print them, blank lines of data appear. I tried searching the archives for tips on this but did not find anything. Basically, I do not want any blank lines to print... whether I have to hide them b4 printing or there is a skip row command, I don't know. Any help would be greatly appreciated.


Posted by bob umlas on December 18, 2001 9:02 AM

You have to hide them before printing. If you have a column which is indicative of the blanks to not print, then either in VBA code or manually, you can select that column, then use Edit/Goto Special, click Blanks, then Click OK. Then Format/Row/Hide.
Then print.