Hi snb,
Fairies came in the night, whilst I was sleeping, and presented me with another, what looks like - and I believe SamT's comment!! - a lightning fast solution!!!!.

The code looks super slick, and I couldn't wait to try it when I saw it, but came across a couple of errors, and I am afraid my understanding of Arrays is a bit limited to say the least!

I first got a 'Variable not defined' error, stalling on sn = sheets, so I added 'Dim sn as Range' ( presuming that is right?)

When I ran it again it stopped with a 'Compile Error' - Expected array, and it highlights the word 'Ubound' in the ReDim statement.

As mentioned I am very green when it comes to arrays, and I am afraid I don't know how to fix this, - can you please help?


Many thanks for your time...........