Hi Garry and Claus,

I tried Garry's revised code and Claus' first code on 6000 rows.
Returns 600 rows.

Both are spot on and under 1 second, (mental clock).

Thank you both, appreciate it.

Glad to help!<g
You might find my 2nd version a tad faster than my 1st. Also, I failed
to toggle ScreenUpdating on the 1st version and so adding that may
speed it up some...

--
Garry

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