Random Team Generator

[spencerr]

Hi

I downloaded a random team generator for work, but I was wondering how I could change the title of the sheet without the document needing to be debug.

I get the message
Run time error '9':
Subscript out of range

I would like to have multiple sheets with the names of the events for each sheet rather than having the name Team Generator.

Thanks

[Jhieminga]

It wouldn't surprise me if the sheet name is used in the programming that creates the teams. It needs to be part of the object identifier when you write stuff to the cells on a sheet (but you can get around it... the question is how smart the programmer was...). The error you mention could be the result of you renaming it.

[spencerr]

Originally Posted by Jhieminga

It wouldn't surprise me if the sheet name is used in the programming that creates the teams. It needs to be part of the object identifier when you write stuff to the cells on a sheet (but you can get around it... the question is how smart the programmer was...). The error you mention could be the result of you renaming it.

thank you so much for your response