I have created a formula which when copied 'down' displays the #Div/0! error
message. This is fine, becasue excel will perform the calculation correctly
when I get to that row but I want to blank that cell when printing so that I
don't get this error message all over my print-out.

Does anyone know a way to blank that cell (without losing the formula) in a
similar way to the concept behind the 'hide zeros' feature?

Thanks,
--
Vicki B