|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub kagawa_Rnd多列乱序() '香川随机乱序数组洗牌法!
- On Error Resume Next
- Randomize
- arr = Selection ': rw = UBound(arr): cl = UBound(arr, 2)
- rw = Cells(1, 256).End(xlToLeft).Column
- cl = Cells(65536, rw).End(3).Row
- For i = 1 To rw
- For j = 1 To cl
- If Len(arr(i, j)) And IsArray(arr) Then '不发挥作用!
- r = Int(Rnd() * ((rw - i + 1) * cl - j + 1)) + (i - 1) * cl + j - 1
- 'i1 = Int(r / cl) + 1: j1 = r Mod cl + 1
- i1 = r Mod cl + 1: j1 = r Mod rw + 1
- t = arr(i1, j1): arr(i1, j1) = arr(i, j): arr(i, j) = t
- End If '不发挥作用!
- Next
- Next
- Selection = arr
- End Sub
复制代码 |
|