|
第3句去掉,或改成 Dim i As Long 就行了
Sub 查找()
Application.ScreenUpdating = False
Dim i As Long
arr = Sheets("全部产品").[a1].CurrentRegion
Set d = CreateObject("scripting.dictionary")
brr = Range("a1:f" & Cells(Rows.Count, 1).End(3).Row)
For i = 2 To UBound(arr)
d(arr(i, 1)) = i
Next
For i = 2 To UBound(brr)
k = d(brr(i, 1))
If k > 0 Then
For j = 2 To UBound(brr, 2)
brr(i, j) = arr(k, j)
Next
End If
Next
Range("a1:f" & Cells(Rows.Count, 1).End(3).Row) = brr
Application.ScreenUpdating = True
End Sub
|
|