Hemant, thanks for the reply, i had previously used your suggestion, my
original coding was exactly like that but when it found the day i was
looking for it would stop the code and give ..Object variable not
set...or something along those lines.

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=557563