You're welcome. Thanks for the feedback!
Biff
"Simon Lloyd"
wrote in message
...
Thanks Biff, worked a treat, it's been driving me mad because i didnt
know how to nest the if statement!
Thanks again,
Simon
--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=540504