I have tried altering the code and tried to find a way to do it without special characters but have had no luck. The HTML (Hypertext Markup Language) Code will display the structure in which the generated card will be displayed. The problem I have is that this code also includes special characters, where I only want the code generated to contain A-Z, 0-9. Use these codes for sweepstakes, marketing promotions, strong passwords, serial numbers. Using this code, when I enter the formula =RandomizeF(9,10) it randomly generates a code 9-10 characters long, and in no particular sequence. Use The Random Code Generator to generate unlimited random codes.
GetLen = Int((Num2 + 1 - Num1) * Rnd + Num1) Public Function RandomizeF(Num1 As Integer, Num2 As Integer) The problem I found with this is that the sequence of numbers and characters would always be the same, where I want it to be completely random and in no pattern.Īfter searching the internet, I have found this code which is the closest I have found to what I am looking for so far: I was going to create the codes using a combination of formula which would include: " =CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)" repeated over as many times as needed. I am trying to create a spreadsheet that can create random code, for use on gift vouchers. I'm very new to using macros, still picking up the basics so forgive me if some parts aren't clear or the answer seems very obvious. Hi, new to the forum and hoping someone can help
0 kommentar(er)
