|
把你那个“调整中”中间的回车都去掉。。。。。。- Sub tt()
- With Sheet1
- r = .[a65536].End(3).Row
- c = .[iv1].End(xlToLeft).Column
- arr = .Range(.[a2], .Cells(r, c))
- End With
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- rq = arr(i, 1)
- If Len(rq) = 0 Then rq = "调整中"
- For j = 2 To UBound(arr, 2)
- ch = arr(1, j)
- If arr(i, j) = "O" Then d(rq & ch) = d(rq & ch) + 1
- Next
- Next
-
- With Sheet3
- r = .[a65536].End(3).Row
- c = .[iv6].End(xlToLeft).Column
- arr = .Range(.[a6], .Cells(r, c))
- For i = 2 To UBound(arr)
- ch = arr(i, 1)
- For j = 3 To UBound(arr, 2)
- rq = arr(1, j)
- arr(i, j) = d(rq & ch)
- Next
- Next
- .[a6].Resize(UBound(arr), UBound(arr, 2)) = arr
- End With
- End Sub
复制代码 |
|