crr(s, j) = arr(i, n)这句提示下标越界
Sub abc()
Dim arr, brr, crr, d, i&, j&, s&, k&, n%
Set d = CreateObject("scripting.dictionary")
arr = Sheet1.Range("a1").CurrentRegion
brr = Sheet2.Range("a1").CurrentRegion
ReDim crr(1 To 20000, 1 To 13)
For j = 1 To UBound(arr, 2)
d(arr(1, j)) = j
Next
For i = 2 To UBound(arr)
If arr(i, 10) = "12" Or arr(i, 10) = "33" Then
s = s + 1
For j = 1 To UBound(brr, 2)
n = d(brr(1, j))
crr(s, j) = arr(i, n)
Next
End If
Next
For k = 1 To UBound(crr)
crr(k, 12) = "ok"
Next
Sheet2.Range("a2").Resize(s, UBound(crr, 2)) = crr
MsgBox "已完成! "
End Sub
crr(s, j) = arr(i, n)这句提示下标越界
没看懂