Use autofilter. Before printing, select "NonBlanks" from the drop-down
menu. After printing,
select "All".

- David

dillon wrote:
Is there a way to write a macro that will recognize and print only those cell
that meet certain criteria? In particular, I have a huge spreadsheet that is
used to order material. When a non-zero quantity is placed in a cell in
column C, it would be great if the program would print only that cell in
column C and the adjacent cells in D, E, F, and G. Any any given time, there
are many cells in column C that are non-zero, but also many that are zero. It
is a waste of paper and time to have to print the entire spreadsheet. Any
ideas? Thank you.