Using Rnd function on VBA in Microsoft Excel

[SirName]

I am having some doubts over the VBA "Rnd" function about if it really generates a random number (between 0 and 1). 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.

[Erakna]

Computers cannot give a "Truly Random" random number, just can't be done, impossible. The nice thing about the VBA Rnd function, though, is you can specify the seed by using "Randomize" like so:

function rand2()
Randomize 12345
rand2 = rnd
end function

Which generates random numbers based on a seed value of 12345.

[Bontu]

As indicated, "random" numbers from the worksheet RAND() function are also predetermined by what came before; but the exact algorithm depends on your Excel version. It also appears that RNGs in the worksheet, Analysis ToolPak, and VBA each uses a different algorithm. ATP, VBA and pre 2003 worksheet algorithms are not suitable for serious simulation work.