when you divide any number by 0 you get an error of "#DIV/0!", so an
error exists and therefore you can use the Error.type formula.
Samo
--
Samo
------------------------------------------------------------------------
Samo's Profile:
http://www.excelforum.com/member.php...o&userid=34413
View this thread:
http://www.excelforum.com/showthread...hreadid=541894