Merging 2 cells in a calendar program

[scott micklo]

Hello

I am having a tough time to program a certain section of my shift schedule program.

In my code, I am attempting to make a monthly calendar, draw boxes around each day, week, and the month.

The calendar is set up so that each day takes up 10 rows. the first row is for the actual date (1st, 2nd....)

The next 9 rows are set aside for scheduling shifts.

I know my code is NOT computer friendly-- it takes a lot of time first filtering through each cell in the first row for the date, then each cell for the formatting of each row. Its the only way i could get it to work.

BUT, I need the first 2 columns in each date to be merged so that i can have it put the shift and the persons name.

For example, if you run test it, using July 2016 as an example, on July 10th, (in cell A&B 24- Axel Rose should be scheduled for a shift of 8am - 10 pm. And David Lee Roth should be in A&B 25 for a 10am - 10pm shift). When you open the attachment, you will see July 2016 and can see how it is looking and where the 2 schedules shlould be.

But I can not for the life of me figure out how to first test if its in the first 2 cells of each day, and merge them, and skip the next column (where at the top of the day is the actuly number).

I appreciate any assistance in getting this task completed in advance.

PS There is much that is still commented out and still work to be done. Once I can get this portion, I will be going back to the user for critiques and revisions of the time formats used. Then it will be all downhill programming after that.

Thanks again.

[bulina2k]

Hi there!
I think you should replace the

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.