You're quite welcome. Glad to help.

I should have added an extra note: The formula I gave you will result
in a blank for all errors except the #N/A error. If you have trouble
with that one as well then change the formula to be ISERROR instead of
ISERR.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=523709