|
发表于 2016-11-28 19:37
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr, d, i&, j%, m&, n%
- Set d = CreateObject("scripting.dictionary")
- ks = [t1]
- arr = Range("d3").CurrentRegion
- For j = 1 To UBound(arr, 2)
- h = (j - 1) * 13 + 4
- brr = Cells(h, "h").Resize(12, 10)
- For i = UBound(arr) - ks + 1 To UBound(arr) - 1
- zf = "数字" & arr(i, j) & ",跟随" & arr(i + 1, j)
- d(zf) = d(zf) + 1
- Next
- For m = 3 To UBound(brr)
- For n = 2 To UBound(brr, 2)
- zf = brr(m, 1) & "," & brr(2, n)
- brr(m, n) = d(zf)
- Next
- Next
- Cells(h, "h").Resize(12, 10) = brr
- d.RemoveAll
- Next
- End Sub
复制代码 |
|