randindex

What is wrong with bellow VBA code Sub TwentyfiveRandOf25ONLY6() Dim myVal As Integer myVal = Range("AT36").Value Dim i As Long Dim randIndex As Long, temp As Long For i = 1 To myVal anArray(i) = i Next i For i = 1 To myVal Randomize Do...

This VBA formula is working perfectly, but I would like to be able control, the amount of numbers (in the case of bellow VBA formula is 28) to be random, from designated worksheet cell, for sample A1. The same refers to choosing the Range (which in this sample is 6) to be able to control from...

I have VBA formula which is working perfectly, but only the results are all in one column and I would like them to appear in one specific row. "Sub TwentyfiveRandOf25ONLY6() Dim anArray(1 To 28) As Long Dim i As Long Dim randIndex As Long, temp As Long For i = 1 To 28...

I have already VBA for random numbers, but I would like to add loop for how many times the random is run and the number foe sample is in Z25 "Sub TwentyfiveRandOf25() Dim anArray(1 To 25) As Long Dim i As Long Dim randIndex As Long, temp As Long For i = 1 To 25...