Thanks for that, works a treat.
Had been trying something along those line but it was the 'HasFormula'
bit that i didnt have.
--
tanktata
------------------------------------------------------------------------
tanktata's Profile:
http://www.excelforum.com/member.php...fo&userid=4598
View this thread:
http://www.excelforum.com/showthread...hreadid=559103