Edit existing macro to include week change

Hello,

Looking for some help editing my current macro on the attached sheet. The macro is titled "Clear" and has a button named on the sheet as "New Week".

I am looking for a way to add to that macro a way to change the week range in merged cells D11:H11 that are currently showing last week. I am hoping that when someone hits the button "New Week" it will run it's current string and then also change the "For the week of" line to whatever the current week is. I.E. this week it would say 6/18/2012 - 6/22/2012.

Any help on this or ideas for a variation would be greatly appreciated.

Employee Work Sheet 1.1.xlsm

Thanks,
Adam

Try this one:

Please Login or Register  to view this content.