|
- Sub Macro1()
- Dim arr, brr, d, d2, rng As Range
- Dim i&, j%, zf$, rng2 As Range
- Set d = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- brr = Sheet2.Range("a1").CurrentRegion
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- zf = i & "," & arr(i, j)
- d(zf) = ""
- Next
- Next
- For i = 1 To UBound(brr)
- For j = 1 To UBound(brr, 2)
- zf = i & "," & brr(i, j)
- d2(zf) = ""
- If d.exists(zf) And brr(i, j) <> "" Then
- If rng2 Is Nothing Then Set rng2 = Sheet2.Cells(i, j) Else Set rng2 = Union(rng2, Sheet2.Cells(i, j))
- End If
- Next
- Next
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- zf = i & "," & arr(i, j)
- If d2.exists(zf) And arr(i, j) <> "" Then
- If rng Is Nothing Then Set rng = Cells(i, j) Else Set rng = Union(rng, Cells(i, j))
- End If
- Next
- Next
- ActiveSheet.UsedRange.Interior.ColorIndex = xlNone
- Sheet2.UsedRange.Interior.ColorIndex = xlNone
- If Not rng Is Nothing Then rng.Interior.ColorIndex = 6
- If Not rng2 Is Nothing Then rng2.Interior.ColorIndex = 6
- End Sub
复制代码 |
|