+ Reply to Thread
Results 1 to 9 of 9

Create random codes

  1. 06-01-2010, 04:20 PM #1
    yrndtn
    yrndtn is offline
    Registered User
    Join Date
    12-31-2008
    Location
    haifa, israel
    MS-Off Ver
    Excel 2007
    Posts
    36

    Create random codes

    Hi,

    I'm trying to create a list of thousands unique codes, that contain numbers and letters. each code should be 10-12 characters and should not be sequences.

    I couldn't find any post regarding that.

    Thanks
    Last edited by yrndtn; 06-01-2010 at 05:09 PM.
    Reply With QuoteRegister To Reply
  2. 06-01-2010, 04:23 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Create random codes

    Why ?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 06-01-2010, 04:36 PM #3
    yrndtn
    yrndtn is offline
    Registered User
    Join Date
    12-31-2008
    Location
    haifa, israel
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Create random codes

    its for promotion coupon codes that users can enter to get benefits.
    Reply With QuoteRegister To Reply
  4. 06-01-2010, 04:38 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Create random codes

    Any particular format, or just random strings of letters and numbers?
    Reply With QuoteRegister To Reply
  5. 06-01-2010, 04:41 PM #5
    day92
    day92 is offline
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Create random codes

    This will do the trick..

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 06-01-2010, 04:44 PM #6
    yrndtn
    yrndtn is offline
    Registered User
    Join Date
    12-31-2008
    Location
    haifa, israel
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Create random codes

    Nothing special, just random strings of letters and numbers.
    Reply With QuoteRegister To Reply
  7. 06-01-2010, 04:46 PM #7
    day92
    day92 is offline
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Create random codes

    Did you try the macro?
    Reply With QuoteRegister To Reply
  8. 06-01-2010, 04:51 PM #8
    yrndtn
    yrndtn is offline
    Registered User
    Join Date
    12-31-2008
    Location
    haifa, israel
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Create random codes

    I Just did and its look like it is doing what I need :-)
    I didn't realize which value I need to change to make it a mass of coupons (I need something like 5000 unique codes). If I have a mass of codes i can just remove duplicates and get the desire results.
    Reply With QuoteRegister To Reply
  9. 06-01-2010, 05:08 PM #9
    yrndtn
    yrndtn is offline
    Registered User
    Join Date
    12-31-2008
    Location
    haifa, israel
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Create random codes

    Well, Just did... "For J = 1 To 50" change to "For J = 1 To 5000".

    Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1