I'm working on a project where I have to create designated teams for office members based on their work schedule. I am working off a Macro template I found in another thread, but it doesnt quite seem to be working. In Column A, starting at A1, I have a list of names (in this case - letters). I'd like to randomly split them up into X amount of groups. I can't seem to find the error in this code. I know there is a function to do this without a macro, but I have a very large data set.
The error I'm getting is "Subscript out of range". The watches box indicates " People : <Out of context> : Variant/Empty : Sheet2.RandomizeCalls"
Could anyone offer some assistance?
Thanks in advance!