Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

OMMIT PRINTING BLANK ROW

Posted by MINASHAH on November 08, 2001 8:45 AM

I HAVE LONG BILL OF MATERIAL IN ENGINEERNING FIRM.
IS THERE ANY WAY IF QUANTITY = 0 OR BLANK THEN THAT ROW WILL BE OMMITED FOR PRINTING. THIS WAY I DON'T HAVE TO PRINT 5 PAGES WHERE I NEED ONLY HALF A PAGE TO PRINT.
i KNOW THIS WILL HELP OTHERS TOO.

How about using an AutoFilter for this?

Posted by Tom Urtis on November 08, 2001 8:51 AM

Your quickest fix would be to do an AutoFilter on the range, once for non-blanks and then again for "does not equal" with 0 as that value. Then print the filtered range.

Tom Urtis

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.