+ Reply to Thread
Results 1 to 1 of 1

Shading cells using code

  1. #1
    Registered User
    Join Date
    11-18-2003
    Location
    Denmark
    Posts
    13

    Shading cells using code

    In the attached Excel file, it is possible for the user to select the day he/she goes to work, and then click a button, which creates a rotation for the remainder of the year, in order to see when user will home and when user will be away.

    It was initially made for just one year at the time, but now a second year has been added. Problem is that I can't seem to get the code changed, in order for both years to come in to use. If I e.g. select August 23, 2010, and click the '28' days button, then 28 days should be shaded, with 28 'empty' days in between, all the way until the end of the second year (in the file 2011).

    Can someone explain/assist with getting this working?

    Thanks.

    /Anders
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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