|
Sub Eee()
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("A65536").End(xlUp).Row
R1 = Range("e65536").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
Range("b1").Resize(d.Count, 1) = Application.Transpose(d.keys)
End Sub
本帖最后由 suye1010 于 2012-12-1 15:46 编辑
- Sub Eee()
- If Range("a1") = "" Then
- MsgBox "无数据可处理。"
- Exit Sub
- End If
- Dim d, Temp, dc, R, R1,arr, arr1
- Set d = CreateObject("Scripting.Dictionary")
- R = Application.WorksheetFunction.CountA(Columns("A"))
- R1 = Application.WorksheetFunction.CountA(Columns("E"))
- 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
- For Each dc In d.keys
- k = k + 1
- Cells(k, 2) = dc
- Next
- End Sub
复制代码
|
|