MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Suppress zero rows on printing


Posted by Bharat on December 11, 2001 6:46 AM

I need to print lengthy reports with 7 columns and want to suppress printing rows containing either a zero or blank.

Can someone please assist

Thanks

Bharat


Posted by Mark W. on December 11, 2001 7:53 AM

Have you considered using an AutoFilter? (nt)