The RegEx stuff is fascinating. I will have to try to break that down to understand the pieces and how it works.


Of course this is the OPs project, but I'm going to take your high_cell procedure and see if I can 1) Prohibit coloring outside the shift range and 2) redefine any existing coloring if the cell code is changed.


Thanks

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

I forgot to write: can be "-" or without, case-insensitive. Code accepts 1-UK1234, 1UK1234, 1-BR, 1-br, 1BR

Good idea!


I thingk the next enhancement would be to ensure tasks can't overlap. For another day. It is getting late.



In the userform version I posted earlier, "L" or Leave can be a set 8 hours or defined with a start and end point. Will have to let OP decide what he wants and code can then be modified.


Have you posted a web page or any other material on construction of RegEx expressions? I've read quite a bit of on them since the last time you helped with one of those but still hard to grasp without good practical examples.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

I have never published anything on any website