Auric_,
For some reason in VBA, InStr() doesn't usually work as it does in VB
and so for reliability I specify a criteria...

found = InStr(1, Sheet1.Cells(L0, 2), Sheet2.Cells(L1, 1)) 0
If found Then Exit For

--
Garry

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