...if I have a loop that calls the random() function 10 times, for example, with a parameter of 20, it will return a sequence of 10 numbers in the range 0 to 19, e.g. 3,11,15,10,4,2,17,18,9,5....what I want to do is repeat the loop and get the same sequence of numbers instead of 10 new ones.
fyi in VB...
Randomize Statement
Initializes the random-number generator.
Syntax
Randomize [number]
The optional number argument is a Variant or any valid numeric expression.
Remarks
Randomize uses number to initialize the Rnd function's random-number generator, giving it a new seed value. If you omit number, the value returned by the system timer is used as the new seed value.
If Randomize is not used, the Rnd function (with no arguments) uses the same number as a seed the first time it is called, and thereafter uses the last generated number as a seed value.
Note
To repeat sequences of random numbers, call Rnd with a negative argument immediately before using Randomize with a numeric argument.
Rnd function Returns a Single containing a random number.
Syntax
Rnd[(number)]
The optional number argument is a Single or any valid numeric expression.
Return Values
If number is less than zero, Rnd generates the same number every time, using number as the seed.
If number is greater than zero, Rnd generates the next random number in the sequence.
If number is equal to zero, Rnd generates the most recently generated number.
If number is not supplied, Rnd generates the next random number in the sequence.
Remarks
The Rnd function returns a value less than 1 but greater than or equal to zero.
The value of number determines how Rnd generates a random number:
For any given initial seed, the same number sequence is generated because each successive call to the Rnd function uses the previous number as a seed for the next number in the sequence.
To produce random integers in a given range, use this formula:
Int(([upperbound] - [lowerbound] + 1) * Rnd + [lowerbound])
Here, upperbound is a field with the highest number in the range, and lowerbound is a field with the lowest number in the range.