|
Sub test()
Dim A, i
A = Range("A1").CurrentRegion
A = test38(1, UBound(A), Int(UBound(A) / 2))
Range("a:b").Interior.ColorIndex = xlNone
For i = 1 To UBound(A)
Range(Cells(A(i), 1), Cells(A(i), 2)).Interior.ColorIndex = 4
Next i
End Sub
Function test38(x, y, z)
Dim arr(), brr(), i, t
ReDim arr(x To y) '数据源
ReDim brr(1 To z) '输出数组
For i = x To y
arr(i) = i
Next
For i = 1 To z
t = Int(((y - x + 1) - (i - 1)) * Rnd) + (x + (i - 1))
brr(i) = arr(t)
arr(t) = arr(x + (i - 1))
Next
test38 = brr
End Function
求助3.rar
(11.5 KB, 下载次数: 9)
|
|