|
是的 86做的是针对一行的 我在86的基础上修改了下 把所有行都给删除了 谢谢 86的解答- Sub demo()
- Dim d As Object, ar, i, j
- Set d = CreateObject("Scripting.Dictionary")
- For j = 2 To Cells(2, 1).End(xlDown).Row
- ar = Range(Cells(j, 1), Cells(j, Cells(j, Columns.Count).End(1).Column))
- For i = 1 To UBound(ar, 2)
- If Not d.Exists(ar(1, i)) Then
- d(ar(1, i)) = ""
- End If
- Next
- Cells(j, 1).Resize(, UBound(ar, 2)).ClearContents
- Cells(j, 1).Resize(, d.Count) = d.keys
- d.RemoveAll
- Next j
- End Sub
复制代码 |
|