"'gotta be a better way to get all this done without doing so many
SELECTIONS"

I don't see in your code why you have to 'select' anything when the
actions your code takes can be done directly on the 'range' it acts on.

Example:

Instead of...
Range("B1:B26").Select
For each c in Selection...

..you could use...
For Each c in Range("B1:B26")...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion