Hi RD,
Thanks for your help. I tried this using ISNUMBER and ISTEXT but it
would not return the correct result either. Maybe I should try a
different approach.
Thanks,
COlin :)
--
colin_b
------------------------------------------------------------------------
colin_b's Profile:
http://www.excelforum.com/member.php...o&userid=36106
View this thread:
http://www.excelforum.com/showthread...hreadid=558799