Troubleshooting - Prevent Duplicate Entries From VBA Code

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.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

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



I'll help you if you do that.

You're searching Column A to see if the generated code exists there, but then putting the new code into column B. Shouldn't you be searching Column B, like so?

Please Login or Register  to view this content.