Generating random numbers within limits and placing in an array:   Return to List

' In this case, RandomSize number of random numbers between 45 & 12000

minr = 45' Lower limit of range of numbers
maxr = 12000' Upper limit of range of numbers
randno = minr + Fix(Rnd * (maxr - minr + 1))' Our generated random number

' ************ A more complete example *****************

Option Base 1
MyLower = Val(RandomStart)' The lower limit of the random number range
MyUpper = Val(RandomEnd)' Upper limit of the random number range
MySample = Val(RandomSize)' The number of random numbers to generate
For r = 1 To MySample
    randno = MyLower + Fix(Rnd * (MyUpper - MyLower + 1))
    ReDim Preserve RandomNumberArray(r)
    RandomNumberArray(r) = LTrim(Str(randno))' An array of our random numbers
Next



Note to Webmaster