Mike,
In that case, I think the only solution would be using a macro - not my
strong point I'm afraid but I'm sure there are others on the site who
may be able to help you.
Ed
--
EdMac
------------------------------------------------------------------------
EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
View this thread:
http://www.excelforum.com/showthread...hreadid=547423