I corrected the ranges that you were using, you had the wrong range in
getting the start date, and one was too large.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"paulrm906" wrote
in message ...

Hello Bif

I got it working I think I must of been doing something very minor
because after I copied Bob's version over and then picked up on a small
error I managered to get it working so thanks to both you and Bob.

Paul Maynard


--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile:
http://www.excelforum.com/member.php...o&userid=28776
View this thread: http://www.excelforum.com/showthread...hreadid=550748