Dear Friends,

I want to check whether cell has #REF ! error? I am trying to get the
values of a cell range. If any cell has an error "#REF!" then
"ActiveCell.value" fails. Whats a way to check whether cell has an
error so I can consider any default value for that cell.

Regards,

Vinit