|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Option Base 1
Sub bbb()
Dim i&, ii&, tt#
Dim A()
Dim B()
ReDim A(88000, 5)
ReDim B(6000, 5)
tt = Timer
For i = 1 To 88000
For ii = 1 To 5
A(i, ii) = i
Next
Next
For i = 1 To 6000
For ii = 1 To 5
B(i, ii) = Int((88000 * Rnd) + 1)
Next
Next
Set dic1 = CreateObject("scripting.dictionary")
For i = 1 To UBound(A)
If Not dic1.exists(A(i, 1)) Then
dic1(A(i, 1)) = i
End If
Next
For i = 1 To UBound(B)
If dic1.exists(B(i, 1)) Then
For ii = 1 To 5
B(i, ii) = A(dic1(B(i, 1)), ii)
Next
End If
Next
MsgBox Timer - tt
[a23].Resize(UBound(B), 5).Value = B
End Sub
[ 本帖最后由 lb_bn 于 2010-3-22 00:12 编辑 ] |
|