Solved: Rearrange elements within 2D array randomly

[Digita]

Hello,

I have a list of values in range A1:A10 to load into an array. I wish to rearrange the elements within the array in a random fashion. I'm stuck with the randomize piece. Any suggestion? Thanks in advance.

Regards



kp

[Digita]

Hi,

Just found this code (http://www.pcreview.co.uk/forums/thread-947520.php) to suit my purpose. Just wondering why "&" is appended to the step digit in line:

For i = UBound(arr, 1) To 1& Step -1&

Thanks & regards


kp

[Bob Phillips]

Totally unnecessary, jsut saying that it is an integer value.

[Digita]

Thanks Bob for the feedback. Have a great day.