|
本帖最后由 hwc2ycy 于 2012-10-8 17:58 编辑
- Sub 删除重复()
- Dim arr, i&, dic, arr2, j&
- Application.ScreenUpdating = False
- arr = Worksheets("B").Range("a1:a" & Worksheets("B").[a1].End(xlDown).Row).Value
- Set dic = CreateObject("scripting.dictionary")
- For i = 1 To UBound(arr)
- dic(arr(i, 1)) = ""
- Next
- arr = Range("a1:a" & [a1].End(xlDown).Row).Value
- ReDim arr2(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- If Not dic.exists(arr(i, 1)) Then
- j = j + 1
- arr2(j, 1) = arr(i, 1)
- End If
- Next
- Range("b1").Resize(UBound(arr), 1) = arr2
- End Sub
复制代码 |
|