error trapping within the overall workbook?

[pjwhitfield]

rather than coding error trapping within forumlas Im wondering if theres an easy way to do it as an overall? Im guessing I could write some code within the Worksheet_Update event but wondered if anyone had done this or whether theres a better way?

eg

I may have a thousand cells with the formula =Ax/Bx

but Im aware that quite legitimately Bx can be zero and therefore will cause a #DIV/0 error which just looks wrong.....so I can wrap the formula in a =IF(ISERROR(Ax/Bx) statement but dont want to have to do that for every item, everytime I add some calculation.


Whats the best way to do this?

[newdoverman]

This might not be the best way but you could use conditional formatting on each worksheet to hide errors by making the font colour white when an error occurs.

Select the worksheet or the range likely to be used and apply this formula in Conditional Formatting.

=ISERROR(A1)