"Rick Rothstein" wrote in message
...
As long as your rule is valid, it seems that your solution
covers all "extraneous" characters. To cover that issue
with Rick's approach would require including all possible
characters in sAlphabet ... which would wipe out the
elegance (and hurt execution time, as well), but it would allow a
variety of rules.

See my latest response to the OP for a still quick, and what I
consider a still "elegant" solution, to covering the non-letter
characters.

Rick Rothstein (MVP - Excel)


Elegant, for sure!

Reading your post after replying to Garry regarding brevity, I recall a
tale I heard many years ago about assembler code that had been running
flawlessly for years which suddenly died. The programmer no longer
worked there, and the team was stumped when they came to a dead-end in
the source code-- there was no instruction to execute! How could the
code have ever worked in the first place?!

Eventually someone realized that with the combination of processor speed
and rotation of the "swap drum" the code was running on the missing
instruction was just coming up under the read head at exactly the right
time, and the program broke when the swap drum was replaced with a head
per track disk.

The development environment has certainly changed since those days!

[BTW: I don't believe I've ever used LIKE in VBA ... I'll have to
remember that one!]

--
Clif McIrvin

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