Thanks bryan the problem with the formula is sorted now. Another problem
I have is when inserting a new row into the middle of the worksheet I
want the formula to automatically copy into the new row. How do I get
this to happen?


--
Neil_Pattison
------------------------------------------------------------------------
Neil_Pattison's Profile: http://www.excelforum.com/member.php...o&userid=27696
View this thread: http://www.excelforum.com/showthread...hreadid=472528