我自己写了一个,可以达到目的,就是超慢,有没有高手帮一下啊!!
sub test()
Dim arr1 As Variant
Dim arr2 As Variant
Dim rrow2 As Integer
Dim i, j, x As Integer
Dim d As Range
rrow2 = Range("A65536").End(xlUp).Row
For j = 1 To rrow2
With Worksheets("sheet1").Range("a1:a" & rrow1
Set d = .Find(arr2(j, 1), LookIn:=xlValues)
If d Is Nothing Then
x = x + 1
Sheets("sheet3").Cells(x, 1) = arr2(j, 1)
Sheets("sheet3").Cells(x, 2) = arr2(j, 2)
Sheets("sheet3").Cells(x, 3) = arr2(j, 3)
Sheets("sheet3").Cells(x, 4) = arr2(j, 4)
Sheets("sheet3").Cells(x, 6) = "没记录"
End If
End With
Next j
end sub |