|
代码稍加修改即可:
- Sub gj23w98()
- Set d = CreateObject("scripting.dictionary")
- For Each sht In Sheets
- If sht.Name <> ActiveSheet.Name Then
- With sht
- arr = .[a1].Resize(59, 12)
- crr = Array(2, 9, 10, 11, 12)
- For i = 5 To UBound(arr)
- For j = 0 To UBound(crr)
- If Len(arr(i, 1)) Then s = Trim(arr(2, 2)) & Trim(arr(i, 1)) & Trim(arr(4, crr(j)))
- If Len(arr(i, crr(j))) Then d(s) = arr(i, crr(j))
- Next
- Next
- End With
- End If
- Next
- brr = [a1].CurrentRegion
- m = UBound(brr): n = UBound(brr, 2)
- For i = 4 To m
- For j = 24 To n Step 5
- For k = 0 To 4
- s = Trim(brr(i, 2)) & Trim(brr(2, j)) & Trim(brr(3, j + k))
- If d.exists(s) Then brr(i, j + k) = d(s)
- Next
- Next
- Next
- [a1].CurrentRegion = brr
- End Sub
复制代码 |
|