Hi, I am trying to create a macro that would generate 3 Character Alpha Numeric Permutations & not getting anywhere with it. Any help would be greatly appreciated.
Sample
A1
A2
.
.
A99
.
A1B
.
B99
.
Z99
Thanks
N
Hi, I am trying to create a macro that would generate 3 Character Alpha Numeric Permutations & not getting anywhere with it. Any help would be greatly appreciated.
Sample
A1
A2
.
.
A99
.
A1B
.
B99
.
Z99
Thanks
N
This may be close to what you need:
Please Login or Register to view this content.
Gary's Student
Hi NB237,
Ponder this formula in a cell...
=MID("123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,35),1)
Then look at this code to debug.pring all possible 3 letter words you are asking for:
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you both, both methods worked beautfully!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks