randindex

  1. Jan Kalop

    VBA what is wrong

    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...
  2. Jan Kalop

    perfecting VBA

    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...
  3. Jan Kalop

    VBA correction

    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...
  4. Jan Kalop

    adding loop in VBA

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top