Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
A friend asked me this question regarding random numbers in VBA If you run the following code: Sub rand() A = 1 For i = 1 To 10 Cells(A, 3) = rnd A = A + 1 Next i End Sub 10 random numbers will appear in A1:A10 Now hit the stop (reset) button in the VBA window and run again. The exact same 'random' numbers appear. Is this expected? Is there a work-around? Regards - Dave. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random phantom breakpoints and random bogus compile errors | Excel Programming | |||
Sorting random Data created from a random formula | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) |