|
Sub kk()
Dim dic As Object, arr_A(), arr_B(), arr()
Set dic = CreateObject("scripting.dictionary")
irow = Sheet1.Cells(Rows.Count, 1).End(3).Row
arr_A = Sheet1.Range("a2:a" & irow).Value
ReDim arr(1 To UBound(arr_A), 1 To 1)
irow = Sheet2.Cells(Rows.Count, 1).End(3).Row
arr_B = Sheet2.Range("a2:a" & irow).Value
For i = 1 To UBound(arr_B)
dic(arr_B(i, 1)) = ""
Next i
For i = 1 To UBound(arr_A)
If dic.exists(arr_A(i, 1)) = False Then
n = n + 1
arr(n, 1) = arr_A(i, 1)
End If
Next i
With Sheet2
.Range("a" & irow + 1).Resize(n, 1) = arr
End With
End Sub
|
|