Hello!
This is my first post here. I have tried to search the forum for the problem i'm having but i can't seem to find any answer to it.
I'm trying to make a rooster for schedules which i'm later going to use the solverfunction with. That i don't have any problems with.
The problem is that for example, cells from B2:AL2 is locked to B1802. Within that range some cells are blank. The blanks represent breaks and lunchbreaks and i've done a total of 64 combinations for each time a new schedule period can start.
Since i locked every cell like my example above from B2 to B1792 i need to clear same cells for 64 rows at the time. Doing this by hand will probably drive me mad.
So my question is: Is there anyway i can create a macro that will clear the same cells within a selected area?
If i select B2:AL3 i like to clear K2, S2:V2, AE2, K3, S3:V3 and AF3. But here i want it to be done in a specific pattern for the selection B2:AL65, C66:AN193 and so on.
Is it possible?
Regards
Kristian
Bookmarks