Trevor & Harald,

Thank you both very much.

This works for me and I am so sorry I did not fully
explore the solution before reposting. I could make
excuses like it was late and I thought I would try to
scrape up a response while I was sleeping, but I should
have tested it before posting anything else.

I am now exploring the use of the Userform. This is
driving me nuts as I do all my stuff in VB6 but this
problem has to be resolved in Excel. I may well be back to
ask more questions later.

Thanks again for your assistance and patience.

Tom