- Option Explicit
- Sub db()
- Dim arr, brr, crr(), i, j, str, drr
- Dim d As New Dictionary, d1 As New Dictionary
- arr = Sheet1.Range("a2:h85")
- brr = Sheet2.Range("a2:h86")
- For i = 1 To UBound(arr)
- str = arr(i, 1) & arr(i, 2) & arr(i, 3) & arr(i, 4) & arr(i, 5) & arr(i, 6) & arr(i, 7) & arr(i, 8)
- If Not d.Exists(str) Then d.Add str, ""
- Next
- For i = 1 To UBound(brr)
- str = brr(i, 1) & brr(i, 2) & brr(i, 3) & brr(i, 4) & brr(i, 5) & brr(i, 6) & brr(i, 7) & brr(i, 8)
- If Not d1.Exists(str) Then d1.Add str, ""
- Next
- ReDim drr(1 To UBound(arr))
- ReDim crr(1 To UBound(brr))
- For i = 1 To UBound(brr)
- str = brr(i, 1) & brr(i, 2) & brr(i, 3) & brr(i, 4) & brr(i, 5) & brr(i, 6) & brr(i, 7) & brr(i, 8)
- If d.Exists(str) Then
- crr(i) = ""
- Else
- crr(i) = "不一致"
- End If
- Next
- For i = 1 To UBound(arr)
- str = arr(i, 1) & arr(i, 2) & arr(i, 3) & arr(i, 4) & arr(i, 5) & arr(i, 6) & arr(i, 7) & arr(i, 8)
- If d1.Exists(str) Then
- drr(i) = ""
- Else
- drr(i) = "不一致"
- End If
- Next
- Sheet1.Range("i2:i85") = WorksheetFunction.Transpose(drr)
- Sheet2.Range("i2:i86") = WorksheetFunction.Transpose(crr)
- End Sub
复制代码 |