Thank you Bob - works a Dream.

However, took me a while to file the Sheet code modual.

I was inserting a modual via the insert menu.

What i did was highlight "sheet1" in Excel objects than under the vie
menu, click code then copied your code in.

Learning all the tim

--
Message posted from http://www.ExcelForum.com