|
字典。
跟你的结果不一样,可能没有完全理解你的意思吧。
- Sub bbb()
- Dim arr, i&, j&, d As Object, rng As Range, s$, c
- arr = [a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If j <> 3 Then s = s & "," & arr(i, j)
- Next j
- If d.exists(s) Then
- If rng Is Nothing Then Set rng = Cells(d(s), 1).Resize(, 5) Else Set rng = Union(rng, Cells(d(s), 1).Resize(, 5))
- Set rng = Union(rng, Cells(i, 1).Resize(, 5))
- Else
- d(s) = i
- End If
- s = ""
- Next i
- rng.Interior.Color = vbRed
- End Sub
复制代码 |
评分
-
查看全部评分
|