|
发表于 2016-11-28 10:11
|
显示全部楼层
本楼为最佳答案
考虑到数值比较规范,都是三位整数,可不用字典,用数组代替,速度还能提高 一点
- Sub 查找填充数据1()
- t = Timer
- Range("G6:G65536,D5").Clear
- Dim Ar, Br, Cr, i As Long
- Ar = Range("C6" & ":C" & Range("C65536").End(xlUp).Row)
- ReDim Br(1 To UBound(Ar), 0)
- Cr = Range("AB12" & ":AK" & Range("AB65536").End(xlUp).Row)
- Dim xrr(0 To 999)
- For i = 1 To UBound(Cr)
- For j = 1 To UBound(Cr, 2)
- xrr(Cr(i, j)) = Cr(i, j)
- Next
- Next
-
- For i = 1 To UBound(Ar)
- Br(i, 0) = xrr(Ar(i, 1))
- If Br(i, 0) = "" Then Br(i, 0) = "无"
- Next
- Range("G6:G65536").NumberFormatLocal = "@"
- Range("G6").Resize(UBound(Br)) = Br
- Range("D5") = "耗时" & Timer - t & "秒"
- End Sub
复制代码 |
|