Thanks again Paul.

You are absolutely right! I found that using this format *4/15/2006*,
did not work. However changing it to *4-15-2006*, did the trick. So now
the code looks in the designated sheet & cell, with the latter format,
and she runs to the end.

Thanks again!

Regards,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=542817