多条件区域删除重复行
http://club.excelhome.net/thread-1327694-1-1.html
(出处: ExcelHome技术论坛)
Sub lsc()
Dim d As Object, Rng As Range
Set d = CreateObject("scripting.dictionary")
With Sheet1
arr = .[a1].CurrentRegion
For i = 2 To UBound(arr)
s = arr(i, 2) & "," & arr(i, 3) & "," & arr(i, 4) & "," & arr(i, 5) _
& "," & arr(i, 6) & "," & arr(i, 7) & "," & arr(i, 8) & "," & arr(i, 9) & "," & arr(i, 10)
If Not d.exists(s) Then
d(s) = ""
Else
If Rng Is Nothing Then
Set Rng = .Rows(i)
Else
Set Rng = Union(Rng, .Rows(i))
End If
End If
Next
If Not Rng Is Nothing Then Rng.Delete
End With
End Sub
|