maybe it would be easier for you to take a look at the workbook?

Steve

"Dave Peterson" wrote in message
...
Depends on what you mean by "look at".

If the total1, ..., total4 ranges are on different sheets, then it'll look
at
them (are they worksheet level names or workbook level names?).

But this line:
ActiveSheet.PrintOut preview:=True, ...
means just the activesheet.




Steven wrote:

will it look at all sheets, only active or only ones listed in the
macro?

Many thanks
Steve

"Dave Peterson" wrote in message
...
if total4 is bigger than 0, then print
if it's not, then check total3. if that's bigger than 0, then print.
if it's not,....

And so forth.

You may want to test it against a small version of your workbook to
see if
it
works the way you want.



<<snipped
--

Dave Peterson