On Aug 24, 3:06 am, "michael.beckinsale"
wrote:
Hi Don,

Many thanks for the code. It isn't quite what l want but l can adapt
the concept to give me what l want.

I wasn't aware of the .Index method

Regards

Michael B

I never had an formal Excel training or education so there is probably
a better way... Enjoy!