Mike,
That's good. I bet that finding it out for yourself will be more valuable
for you in the future that it would have been if I had told you all that in
detail (although it was not a deliberate ploy on my part<vbg). There are
other ways to do it (via the
VB IDE) but you found what I think is the best
way.
Good luck with it all.
Regards
Bob
"mikewild2000" wrote in message
...
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 view
menu, click code then copied your code in.
Learning all the time
---
Message posted from http://www.ExcelForum.com/