Merging cell to the right based on value.

[Coretex]

Hello, I have a timetable, I am looking to be able to merge the cells of how long a class is running for.

This is my range, Set rngMerge = Range("C3:L11") 'Set the range limits here

The timetable is very basic,

9 9:30 10 10:30 11 etc...
Mon
Tue
Wed
Thur
Fri

I currently have the information of the course passed to the start time of the course, so just in cell C4 for example, I need to be able to have the cells merge to the right for when it ends.

I am currently trying to do this by EndTime - Starttime, this gives me how many minutes the course runs for, I divide this by 30 (interval) This gives me the number of cells that I should merge it to the right for.

How can I translate this into code using a For Each cell In rngMerge, thanks

 

[bhos123]

Where do you have Start time and , and End time?

can you post the table if possible?

 

[Coretex]

The start and end times are just cells A2 and A4 on another sheet, it uses a drop down time list, so 9, 9:30, 10 etc