|
- Sub lqxs()
- Dim Arr, i&, d, Brr, x$
- Set d = CreateObject("Scripting.Dictionary")
- Application.ScreenUpdating = False
- Sheet1.Activate
- Arr = Sheet2.[a1].CurrentRegion
- For i = 2 To UBound(Arr)
- If Not IsError(Arr(i, 3)) Then x = Arr(i, 1) & "|" & Arr(i, 2) & "|" & Arr(i, 3) & "|" & Arr(i, 4): d(x) = ""
- Next
- [a1].CurrentRegion.Interior.ColorIndex = xlNone
- Brr = [a1].CurrentRegion
- For i = 3 To UBound(Brr)
- x = Brr(i, 3) & "|" & Brr(i, 5) & "|" & Brr(i, 9) & "|" & Brr(i, 7)
- If Not d.exists(x) Then Cells(i, 1).Resize(1, 12).Interior.ColorIndex = 6
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|