Hi Paul
Many thanks for your prompt response. As you can see I am not a VBA expert. I have simply copied code from elsewhere and tried to modify it to achieve my aim.
I will try your suggestions this evening and see where that gets me.
Thanks again.
Tony