- Sub text()
- Dim arr(1 To 32, 1 To 2), brr, i%, d, j%, m%, r, ws As Worksheet
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To 32
- arr(i, 1) = Application.Dec2Bin(32 - i, 5)
- arr(i, 2) = 33 - i
- d(arr(i, 1)) = arr(i, 2)
- Next
- Range("E2:S11").ClearContents
- Columns("C:D").ClearContents
- brr = Range("E2:S11")
- For i = 1 To UBound(brr)
- For j = 1 To UBound(brr, 2)
- For m = 1 To 5
- Set ws = Worksheets(m)
- r = IIf(ws.Cells(i + 1, j + 4).Value = "", "0", ws.Cells(i + 1, j + 4).Value)
- brr(i, j) = brr(i, j) & r
- Next
- brr(i, j) = d(brr(i, j))
- Next
- Next
- Range("E2:S11") = brr
- Range("C2").Resize(32, 2) = arr
- Columns(3).NumberFormatLocal = "00000"
- End Sub
复制代码 |