My Rnd always gives the same values

[PJfan]

I have created a VBA program that gernerates a random number for me. I have this program looping, and if I tell it I want it to generate ten sets of ten different random numbers, it will do it. But if I ask it to generate ten different sets of ten different random numbers, these ten sets will be the same as the ten sets from the first time I asked it to generate them. Does anyone know why this will happen? Thanks for your help.

Jeremy I'm Thumbing my way back to Heaven.

 

[JohnYingling]

Did you call Randomize first.

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

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[CarlosdB]

USE rANDOMIZE