Steve,

Look at Conditional Formatting with Cell Value ="#REF!"

--
sb
"Steved" wrote in message
...
Hello from Steved

I would like to know is it possible in VBA to find #REF!
in any cell in the worksheet and color the text white as
to give the appearence the cell is blank.

Thankyou.