No that does not do what i want it to :-(

Thanks anyway

Anybody else have any suggestions?

"AndyRoo" wrote:

Have you tried using the autofilter option? It is in the Filter submenu on
the Data menu. You can set it so items with a value of zero are not
displayed.

"nickname" wrote:

I have created a new workbook and in cell B1 I have put the formulae
"=IF(ISBLANK(A1),"",44)". I have then used the fill down function to fill it
down to row 65536. When I go to file print preview its going to print 1821
blank pages. How can I stop it from printing cells that show no value but
contain formulae?