|
本帖最后由 hwc2ycy 于 2012-12-1 15:48 编辑
- Sub Eee()
- Dim t#
- t = Timer
- If Range("a1") = "" Then
- MsgBox "无数据可处理。"
- Exit Sub
- End If
-
- Dim d, Temp
- Dim R&, R1&
- Dim arr, arr1
-
- Set d = CreateObject("Scripting.Dictionary")
- R = Range("A" & Rows.Count).End(xlUp).Row
- R1 = Range("e" & Rows.Count).End(xlUp).Row
- arr = Range("A1:A" & R).Value
- arr1 = Range("e1:e" & R1).Value
-
- For Each Temp In arr
- d(Temp) = 1
- Next
- For Each Temp In arr1
- If Not d.Exists(Temp) Then
- d(Temp) = 1
- Else
- d.Remove (Temp)
- End If
- Next
-
- Dim arr3(), k&
- ReDim arr3(1 To d.Count, 1 To 1)
- For Each Temp In d.keys
- k = k + 1
- arr3(k, 1) = Temp
- Next
- Range("b1").Resize(k, 1) = arr3
- MsgBox Timer - t
- End Sub
复制代码 |
|