VBA "Rnd" Function: Truly Random?

[TheRobster]

Hi,

I am having some doubts over the VBA "Rnd" function about if it really generates a random number (between 0 and 1). In the Help file, it states that:

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 Rnd generates
Less than zero The same number every time, using number as the seed.
Greater than zero The next random number in the sequence.
Equal to zero The most recently generated number.
Not supplied 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.

Before calling Rnd, use the Randomize statement without an argument to initialize the random-number generator with a seed based on the system timer.

Does this mean that after the first random number is generated, this is used as the seed for the next one and that the number sequence from then on is pre-determined?

What I actually want is the VBA equivalent of the worksheet RAND() function, but I need truly random numbers, not ones that are pre-determined by what came before!

So if I have the following code:

Let i = 1 to 1000
Range("A1") = Rnd
next i

Does that generate 1,000 truly random numbers or will they be in a pre-determined sequence?!!?

Thanks
-Rob

[dglienna]

That's about as random as you can get with vba. If you don't use the RANDOMIZE command before calling your sequence, you will get exactly the same numbers if you run it again. If you do call it, the sequence will be different each time.

Do you want to generate a number between 0 and 1? That is what you will get.
You can also say Int(Rnd*???)+1 where ???= the upper bound you want to pick from (minus 1). If you use 6, than the sequence of numbers will be between 1 and 6

[TheRobster]

Hi,

Yes I just want to generate random numbers between 0 and 1, but I want them to be different each time the code is run. I don't want to use seeded values.

How would I use the Randomise function? What is the code?

Thanks
-Rob

[RobDog888]

Just place the call "Randomize" before your rnd code. It will help to make sure your numbers will not be repeated during each run. Also, check out the help file docs on Randomize for a more indepth explaination.

Randomize
 
Let i = 1 to 1000 '<-- Shouldnt it be For and not Let?
    Range("A1") = Rnd
next i

[szlamany]

What I actually want is the VBA equivalent of the worksheet RAND() function, but I need truly random numbers, not ones that are pre-determined by what came before!

Use RANDOMIZE once.

Next call to RND() has been seeded by RANDOMIZE to be a random number.

Then each RND() will return a random number based on a seed of the prior random number - which is pretty random wouldn't you agree??

That is as random as it gets.

[RobDog888]

Unless you use .NET which has a more random randomizer.