Thread: Random
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shapper shapper is offline
external usenet poster
 
Posts: 22
Default Random

Hello,

I have an array as follows:

Dim data(1 To 6, 1 To 6) As String

Then I give values to my array:

data(1,1) = "Value 1"
data(1,2) = "Value 2"
....
data(6,6) = "Value 36"

How can I, after all values had been assigned to data, randomly
redistribute them?

Thanks,
Miguel