@jimmythehand: ah... i see... I'm in the states, so our weeks start on Sunday... but I did change it to vbSunday to accomodate this...

I've changed a few other things to accomodate all of my particular needs, but none of the things I've changed should cause it to react as such... i've attached a simplified copy of the workbook to this post.

Normally, the worksheet is filled with formulas that are linked to another sheet that is a query to a table in an access database. All of those things have been removed from the version I've uploaded, but, as expected, the code still acts in the same manner. Can you take a look?

@Charlize: wow... so that's what that does... that's going to come in hand thanks for clearing that up for me!