Random number

[wmorrison49]

Hi everyone,
I am trying to get this macro to pick a random number between 1 and 1000. It doesn't seem to be doing it, as I have only seen a couple values lower than 250 or higher than 750 out of a lot of trials. Also, it seems to like to pick 706 and 534. Any ideas? Thanks.

Here's what I used:

MagicNumber = Int((1000 * Rnd) + 1)

[sweep]

Hi,

Adding the randomize function prior to your statement may help

Please Login or Register  to view this content.

[bettatronic]

... it should work...

try this one yet:

Please Login or Register  to view this content.

[wmorrison49]

I tried that first one and it worked like a charm. Thanks! What does "Randomize" do to the code?

[bettatronic]

What does "Randomize" do to the code?

Randomize uses number to initialize the random-number generator. Actually setting the new seed value...

[wmorrison49]

Why didn't mine work before? I thought that RND would do the randomizing for me? And why were 706 and 534 coming up all the time?