I have a working sample that sorts the list (not the sheet) and sets up
an index for the row# for each item. If you post your email address
I'll send it on.

--
Garry

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