On reading your post again, I realised that you may be intereted in
finding out "WHICH" cell is in error and not just HOW to find out
whether a cell is in error?

Well, only way i know is to go thru cell by cell for the desired range
and find out...

-feltra


On Jan 9, 9:33 pm, Andrew HUANG
wrote:
Hi, All,

Some cells may be error, such as #REF!. How to know which cell is in error?

Thanks,
-Andrew