+ Reply to Thread
Results 1 to 6 of 6

Non Repeating Random Number Generator

  1. #1
    Forum Contributor
    Join Date
    09-13-2011
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    111

    Non Repeating Random Number Generator

    Hello Everyone,

    First off, thanks for looking at this post. I'm relatively new to coding in VBA and am starting to get a little bit of it. But, I have this random number generator (I didn't code it) that I've been using. Unfortunately, it's been crashing when I've been trying to modify it. I think the chance of it crashing increases as the range of random numbers decrease in proportion to the amount of numbers you want to generate increases.

    In any event, here's what I would like the code to do:
    1. List numbers 1-50
    2. List all 50 numbers random
    3. No repeats.

    Below is the code:
    Please Login or Register  to view this content.
    Last edited by jeffreybrown; 11-27-2012 at 07:12 PM. Reason: Please use code tags...Thanks.

  2. #2
    Forum Contributor
    Join Date
    09-13-2011
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    111

    Re: Non Repeating Random Number Generator

    The attachment contains the file with the macro.
    Attached Files Attached Files

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Non Repeating Random Number Generator

    Hi,

    Are you just wanting to list the numbers 1 to 50 in a random order or generate 50 non repeating random numbers?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Non Repeating Random Number Generator

    Try
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Non Repeating Random Number Generator

    I have a numbers game on my website that is probably what you're after.
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  6. #6
    Forum Contributor
    Join Date
    09-13-2011
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    111

    Re: Non Repeating Random Number Generator

    Hi Guru,

    Thanks a bunch. It worked perfectly!

    Thanks,
    Bob1980

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1