Linda

Just a head's up.

The ISERROR will mask all errors that arise and could mask some other error
that is undesirable like #REF! or #VALUE! or #NAME?


Gord Dibben Excel MVP

Thanks Paul and CLR...both worked...what is the difference in the
statements?