Randomized with the special room

[RJ1969]

Hello,

Can someone please modify the code. With this workbook (page 1), The columns for rooms have 10 and 30 cells. Columns B,D,FH,J,L,N,P,R,T from cells 2 thru 31.
I need Room 22 which is always be in AH11 will only have 25 counts and the rest of the rooms will have 55. That 25 counts for room 22, can it not be past J columns when it randomized? The specials room will need to change if its required.

Also, page 2, I need a separate code in different module which there is not term. Just randomized it with no special room. B33:T62. The highlighted columns.

Thank you in advance

[RJ1969]

Forgot to include the code that does not work yet.

Please Login or Register  to view this content.