I have some VBA code that I had some help building to generate a random 5-character code with the format: letter-number-letter-number-letter (e.g. d6s8b). The code seems to be working just fine but there should be 1.7 million options and we've created roughly 6,000 codes and we have already come across 8 duplicate codes that were generated. I thought the code would be preventing that, so I'm not sure why this is happening. Anyone's help would be greatly appreciated!
Our code is below:
![]()
Please Login or Register to view this content.
Bookmarks