Leath,

Thanks for chiming in. I'm about to leave for the day, so won't respond until tomorrow if you reply.

I'd love to use Autofilter. That's my problem, I can't get it to work on a mixture of numeric and alpha numeric characters. For instance, if I want to find all the values in the range 00 to 89, if I do a custom filter and put in "Is greater than or equal to" and put in either a "0" or "00", then do an "And" "Less than or equal to 89", I get NO results. Same if I try for C0 and H9.

I'll have sort for 7 different ranges altogether, in 7 different steps. The user's won't have to input anything, my macro will perform the filters for their specific region. So, I'll need to automate the filter for the following ranges: 
00-89
9O-B9
C0-H9
I0-J9
K0-K9;L0-P9,R0-ZZ
KA-KZ
Q0-Q9
I think I can write all the rest of the code, I just can't figure out how to get an autofilter to pull up those specific ranges. You've been a big help before, so I hope you can help me on this one.

Thanks,
John