+ Reply to Thread
Results 1 to 1 of 1

Impossible to find the problem with Month starting with Monday

  1. #1
    Registered User
    Join Date
    02-20-2012
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Impossible to find the problem with Month starting with Monday

    As it is difficult for me to explain, check directly the attached file.
    The macro is made to manage different shift in a team.
    On the start Tab, the button "Calendar" allows to create a month calendar (the other button only allows to change shifts).

    All is working perfectly ... until you choose a month starting on a Monday (e.g. 10.2012 or 04.2013).

    The problem is surely coming from the following part of the part of the macro:

    Please Login or Register  to view this content.
    This allows me to compare the first day of the month and use it to start the table.
    Apparently, it does not like when using Monday the first ...

    I thought about using a "If, else" to match MyStr3 with the cell in the table, and directly select one cell (would only be 7 lines of control), but it does not work either (not at all this time !!!).

    I would really appreciate some help. I have spent 2 days on it, and get crazy !!!
    Attached Files Attached Files
    Last edited by Paul; 02-20-2012 at 04:26 PM. Reason: Added code tags for new user. Please do so yourself in the future.

+ Reply to Thread

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