Pattern Building VBA Code - Working code, would like to use cleaner code

Good Day,

I have a VBA Macro that is used to generate shift patterns based on the number of required shifts for each day of the week.

The code that I wrote works, but I'm sure it can be significantly trimmed down to do the same function with less code. I had a hard time looping the pattern back around to the earlier days of the week, so this is the best I can come up with.

I have attached my sample workbook, to see if anyone can possibly show me a better solution to the problem.

Thanks for anyone who is willing to help me.

Chris

Please Login or Register  to view this content.

Wow, thats great.

Thanks so much.

Chris

any time. Please mark it as solved otherwise tell us what needs to be tweaked...

Actually, it doesn't quite work. Seems to ignore the 7th day. It never puts a day off on the 7th day, which makes cycle pattern break.

Let me take a closer look by comparing the parameters to your original...