"Clif McIrvin" wrote in message
...
"Rick Rothstein" wrote in
message ...
Really nice, Rick!

Thanks, but I still think there is a simpler underlying algorithm
available to solve this problem... I'll be looking again at this
problem a little bit later.



After getting my code working correctly, I still had one pesky
question rattling about inside my skull that just wouldn't go away:

Was there any really significant difference between my approach of
doing all the work "inside VBA" using arrays as contrasted with Rick's
approach of using worksheet methods?

That question bothered me enough I put together a little test to check
execution time.

[ ]

I forgot to add that if anyone wishes to compare any of the other
solutions posted in this thread I constrtucted my [ RunTest ], [
SetupResults ] and [ SetupTest ] procedures so that additional
procedures can be added without too much trouble (I hope! <g ).

--
Clif McIrvin

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