Ask manipulate array in vba

[daboho]

I have coding to random unique
Use array but i not understand with little code
This is coding

Please Login or Register  to view this content.

I dont understand with this line code
Y=a(i,1) 'y = 1,2,3,4,5,6,7...15
a(i,1) =a(x,1) 'a(i,1)=random unique
I want somebody to explain me line this coding,

[jindon]

It is swapping the value between a(i, 1) and a(x, 1).

a = [{1;2;3;4;5;6;7;8;9;10;11;12;13;14;15}] all unique

So, swapping the contents inside the array will randomly re-locate each value within the array.

[daboho]

Thank jindon for your explain
y = a(i,1) >> y = {1,2,3 ...15}
a(i,1) = a(x,1) >>a(i,1)= a(1,1)..until a(15,1) .value = random ( 1 to 15)
a(x,1) = y >> random a(row) = [1,2,3 dst until 15]
If i am can to learn proses with debug.print