Sorry about that the overall range is G11:CX287

I tried to stop it at CP so it would not go beyond the range

The code creates a work shift 32 columns wide ,and the offsets add i
the breaks and lunchs. The overall range is an entire day starting a
12:00am
at 15 minute intervals until 11:45PM.

My problem is that if someone works a late shift let's say they star
at 7PM(CE11) I need to set up a break for them but not a lunch and
second break because it will go out of the range.

Thank

--
Message posted from http://www.ExcelForum.com