Re: Using rnd() in VBA
Yes, it is possible. From VBA Help
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.
Before calling Rnd, use the Randomize statement without an argument to initialize the random-number generator with a seed based on the system timer.
Last edited by thomach; August 23rd, 2005 at 08:32.
Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.