printing issue/macro needed

[Brendan Fitzgerald]

I have an Excel problem that I am at wit’s end about. I need a macro (or any
function/tool that will do the job) so that when I print out my worksheet, if
there is a page that has every value set to zero then, when I go to print out
the entire worksheet, those pages will not print.

 

[Susan]

wow. can probably be done but would be complicated. how 'bout if you
loop through the whole spreadsheet first and hide the rows that
contain all zeros, then just print out what's left?
probably won't work for your purposes, but just an idea.
susan

 

[Ron de Bruin]

Hi Brendan

Use Data>AutoFilter if your data is in a table to filter a column for <> 0