|
- Sub Macro1()
- Dim arr, brr, ar, d, d2, i&, j%
- Set d = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a1").CurrentRegion
- brr = Sheet2.Range("a1").CurrentRegion
- ReDim ar(1 To UBound(arr))
- For i = 2 To UBound(arr)
- p = ""
- For j = 1 To UBound(arr, 2)
- p = p & "," & arr(i, j)
- Next
- ar(i) = p
- d(p) = i
- Next
- Application.ScreenUpdating = False
- For i = 2 To UBound(brr)
- p = ""
- For j = 1 To UBound(brr, 2)
- p = p & "," & brr(i, j)
- Next
- d2(p) = i
- If d.Exists(p) Then
- Sheet2.Cells(i, 1).Resize(1, UBound(brr, 2)).Font.ColorIndex = 3
- Else
- Sheet2.Rows(i).Hidden = True
- End If
- Next
- For i = 2 To UBound(ar)
- If d2.Exists(ar(i)) Then
- Sheet1.Cells(i, 1).Resize(1, UBound(arr, 2)).Font.ColorIndex = 3
- Else
- Sheet1.Rows(i).Hidden = True
- End If
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|