|
请测试!
- Option Explicit
- Sub test()
- Dim d As Object
- Dim arr, brr(1 To 10000, 1 To 1)
- Dim i As Long, j As Long
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet2.Cells(1, 1).CurrentRegion
- For i = 1 To UBound(arr)
- If Not d.exists(arr(i, 1)) Then d.Add arr(i, 1), ""
- Next i
- arr = Sheet1.Cells(1, 1).CurrentRegion
- For i = 1 To UBound(arr)
- If Not d.exists(arr(i, 1)) Then
- j = j + 1
- brr(j, 1) = arr(i, 1)
- End If
- Next i
- Sheet1.Columns(3).ClearContents
- Sheet1.Cells(1, 3).Resize(j) = brr
- End Sub
复制代码
|
|