"GS" wrote in message
...
Clif McIrvin submitted this idea :
In Rick's code, he copies Col B below A, then sorts ...

Yes, I know. I added the sort to colB in case the data was not
contiguous. (As is the case after the code is run, then re-run)



Actually, Rick's code handled that just fine as posted ... I
accidentally did that while testing ... then studied his code some more
to see why it didn't fail <g. His .copy didn't care that there was
dis-contiguous data, and after he sorted the result the data was all
contiguous again.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)