Many thanks Dick, I'll give it a whirl



"Dick Kusleika" wrote in message
...
OK ... that explains why it hasn't worked for me ...
Would it work if I stored the cell.address of each successful find of
(i) as say 'last_ i_add'
and then, instead of using FindNext(i)
I used Find (i) with the option After 'last_i_add' .... similar to
code below

Yes, that would work. I didn't check the syntax, but the idea is solid.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com