"VB" skrev i en meddelelse
...
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

Hi Vicki

One way:

=IF(ISERROR(YourFormula),"",YourFormula)

--
Best regards
Leo Heuser

Followup to newsgroup only please.