Great, thanks this works. As an aside it will not work if any cells are
merged - took a while to work this one out as I kept on getting an
error message.


--
st120869
------------------------------------------------------------------------
st120869's Profile: http://www.excelforum.com/member.php...o&userid=18330
View this thread: http://www.excelforum.com/showthread...hreadid=484245