You are welcome. Glad it worked out.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Correction:

My stupidity

When I renamed the worksheets I just picked a day. Seems the names of the
sheets did not correspond dates used with actual Monday dates. First one was
renamed 09-15-05. The actual Monday should have been 09-19-05.

Once the names were changed to match dates for Mondays the code worked
wonderful.

Thanks for all your help.

Ccrosby

{snip}