MrExcel Publishing
Your One Stop for Excel Tips & Solutions

random numbers


Posted by fred on December 05, 2001 10:21 AM

i need 10 random numbers between 1 and 18, and
i need 27 random numbers between 1 and 53.


Posted by Mark W. on December 05, 2001 10:48 AM

How about...

{10;18;17;16;5;8;1;12;3;9}

and...

{28;26;44;35;51;43;25;11;30;13;3;15;19;36;49;9;48;10;50;47;21;17;20;32;45;14;53}

Posted by IML on December 05, 2001 11:41 AM

very clever (nt)

Posted by Bruno on December 06, 2001 2:08 AM

Try this :

MyMax = 18
For dummy = 1 To 10
Cells(dummy, 1) = Int((MyMax * Rnd) + 1)
Next