check cell for #REF!
 

How do i check if a cell has #REF! anywhere in the cells formula?

ie check if Range("A1").formula =#REF! Or ='Sheet1'#REF! or any formula with
#REF! in it.

Thanks

Clayton

check cell for #REF!
 

Clayton,
If Range("A1") = CVErr(xlErrRef) Then

NickHK

"mcphc" wrote in message
...
How do i check if a cell has #REF! anywhere in the cells formula?

ie check if Range("A1").formula =#REF! Or ='Sheet1'#REF! or any formula
with
#REF! in it.

Thanks

Clayton