Programming an IF condition in relation to randomizing rosters...

[machinegod]

Is it possible to modify this code that randomizes all the rosters on the spreadsheet I attached so that when a 'Unique' value is obtained, it is left alone?

Would it be another IF statement I have to add? Something like, IF value of pair is 'Unique', leave alone, and randomize the rest until they're "Unique". I want to make it so that I can randomize for 100% 'Unique' results more effectively. Right now the desired percentage is at 92% because I haven't been able to get anything closer to 100%.

Please Login or Register  to view this content.

I've attached a sample of the workbook. All the names are Marvel or DC character names.

Let me know if I need to clarify anything.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Pepe Le Mokko]

Administrative Note:

Please don't quote entire posts unnecessarily as you did in your previous threads. They are just clutter and make threads hard to read.
Use the "Quick reply" instead
Thanks

[machinegod]

Does anyone know of a good website where someone might know how to solve the issue?

[Pepe Le Mokko]

When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. That is why I reminded you of them. Giving me negative rep for this is awkward at the least.
This being said if your thread is still unanswered perhaps your explanation needs clarification ?

(link above in the menu bar)