| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random
Hello Miguel,
Sub t1() Dim data(1 To 6, 1 To 6) As String Dim vrndarray Dim i As Long, j As Long vrndarray = VBUniqRandInt(36, 36) For i = 1 To 6 For j = 1 To 6 data(i, j) = "Value " & vrndarray(i * 6 + j - 6) Next j Next i End Sub You can find my UDF vbuniqrandint he http://www.sulprobil.com/html/uniqrandint.html Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
