"PY & Associates" wrote in message
...

1 What is OP's ranges please?

OP - original poster, Luke in this case.

2 rows.count or 65536 is purely personal preference.
I choose 65536 because I can see this number;
I most likely cannot remember rows.count;
I am not as young as I want myself to be.

Well maybe. personally I cannot ever remember 65336 - oops there you go <g

Also, 65536 will not work in Excel 95 for exam,ple, as there were not that
many rows, and will there ever be more?

3 we are not sure what the REAL list looks like.
Is C a label, or column label, why cells(nrs,1) is under C?
so loop to 2 or 3 is only our demo how the code works.

We are learning from each other.

No, you are absolutely right, but to be sure we both should have coded for
numbers.