Results 1 to 3 of 3

Edit existing macro to include week change

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    28

    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
    Last edited by adamsurpren; 06-19-2012 at 08:12 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1