Try...
Sub Scan_In_Check()

Hi Garry,

That smoothed the wrinkles out quite nicely.

Minor typo

sMsgs$

sMsg = "No match found!"

but easily corrected.

Good catch! I added that in my reply then updated the macro. Should be

sMsg$

Turns out I actually need to look at three different ranges to assure
non dupes so it was pretty easy to replicate the third range code
from what was already there.

On to exporting to the monthly sheets with date/time stamp.

Thanks for the great help.

You're welcome! Thanks for the feedback...

--
Garry

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