Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
Sub jvr()
Set jv = Cells(1).CurrentRegion.Columns(1).SpecialCells(2)
With Application
a = .RandArray(jv.Count, 1)
ReDim ar(3, 8)
For i = 1 To UBound(a)
If jj = 9 Then jj = 0: j = j + 1
ar(j, jj) = .Index(jv, .Match(.Small(a, i), a, 0))
jj = jj + 1
Next
Cells(2, 3).Resize(UBound(ar) + 1, UBound(ar, 2) + 1) = ar
End With
End Sub
Sub jvvv()
jv = Cells(1).CurrentRegion.Resize(, 9)
a = Application.RandArray(UBound(jv), 1)
For i = 1 To UBound(jv)
If jj = 9 Then jj = 0: j = j + 1
jv(j + 1, jj + 1) = jv(Application.Match(Application.Small(a, i), a, 0), 1)
jj = jj + 1
Next
Cells(2, 3).Resize(4, 9) = jv
End Sub
Sub M_snb()
Randomize
sn = Range("A1:A28")
st = Array(Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd, Rnd)
ReDim sp(3, 9)
For j = 0 To UBound(st)
sp(j \ 9, j Mod 9) = sn(Application.Match(Application.Large(st, j + 1), st, 0), 1)
Next
Range("C20:K23") = sp
End Sub
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.