+ Reply to Thread
Results 1 to 2 of 2

Random numbers without repetition

  1. #1
    Registered User
    Join Date
    12-21-2005
    Posts
    3

    Random numbers without repetition

    Hi.
    I've got a macros to fill 4000 rows with unique random numbers from 1 to 30 in B2:AE4001 area.
    Every row like this:
    14 11 28 20 12 7 30 18 26 13 19 5 6 21 16 25 9 4 8 15 1 27 3 10 24 22 2 23 29 17
    I need to fill 162 sheets. The code works good and fast but after a few sheets it gives me the same set as on sheet 1, then as on sheet 2, etc . So I've generated identical sheets as result.
    Is it possible to avoid that repetition by modifying the code bellow?
    Thanks.
    Please Login or Register  to view this content.
    Last edited by Mike7; 05-24-2008 at 07:21 PM. Reason: spelling

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650
    Hi, You could try the "Randomize" statement before the loops.
    Regards Mick

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1