I know the feeling, I hate FIND, it seems such a flaky implementation.Originally Posted by Cyberdude
I thinjk the problem that by comparing a single cell value againsta range of dates, it doesn't match. If you try xlFormulas for the Lookin, I think it will do what you expect.