Hi Stuart

You could wrap your formula in an Iserror statement
=IF(ISERROR(your_formula),"No Document",your_formula)

--
Regards

Roger Govier


"Stuartf" wrote
in message ...

But it would be nice to display something else instead of #VALUE! Like
No Document ??? any suggestions??


--
Stuartf
------------------------------------------------------------------------
Stuartf's Profile:
http://www.excelforum.com/member.php...o&userid=34535
View this thread:
http://www.excelforum.com/showthread...hreadid=545007