Sub 查询()
Dim r%, arr, brr()
arr = Sheet2.Range("a2:a" & Sheet2.Range("a65536").End(3).Row)
ReDim brr(1 To UBound(arr), 1 To 1)
For r = 1 To UBound(arr)
m = m + 1
brr(m, 1) = Application.VLookup(arr(r, 1), Sheet1.Range("a2:b9"), 2, 0)
Next
Sheet2.Range("c2").Resize(m, 1) = brr
End Sub
Sub 查询()
Dim r%, arr, brr()
arr = Sheet2.Range("a2:a" & Sheet2.Range("a65536").End(3).Row)
ReDim brr(1 To UBound(arr), 1 To 1)
For r = 1 To UBound(arr)
m = m + 1
brr(m, 1) = Application.VLookup(arr(r, 1), Sheet1.Range("a2:b9"), 2, 0)
Next
Sheet2.Range("c2").Resize(m, 1) = brr
End Sub