|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub sss()
- Dim d As Object, arr, c As Range, i&
- Set d = CreateObject("Scripting.Dictionary")
- With Sheets("sheet2")
- arr = .Range("a1").CurrentRegion
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = d(arr(i, 1)) + 1
- Next
- For i = UBound(arr) To 2 Step -1
- If d(arr(i, 1)) > 1 Then
- If c Is Nothing Then
- Set c = .Cells(i, 1)
- Else
- Set c = Union(c, .Cells(i, 1))
- End If
- d(arr(i, 1)) = 1
- End If
- Next
- If Not c Is Nothing Then c.EntireRow.Delete
- End With
- End Sub
复制代码 |
|