|
发表于 2015-10-12 10:14
|
显示全部楼层
本楼为最佳答案
用数组批量查找。- Sub 查找()
- Application.ScreenUpdating = False
- Dim i As Integer
- 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
复制代码 |
|