Hi
Just Like to thank you again for the time you gave my problem. Sorry it has taken so long for final comment but I have adapted your code into my spreadsheets and it does exactly what I wanted.

As regards blocking of macro, I'm still nowhere with that. Got on to MS Office on chat, hadn't a clue why I had the problem. Had him looking through my installation but still no idea. But as you've solved my problem it doesn't matter now.

Thanks again.