|
- Sub demo()
- Dim dic As Object, i%, arr, irow%, AR
- Set dic = CreateObject("scripting.dictionary")
- arr = Sheets("民族代码").Range("a1").CurrentRegion
- For i = 1 To UBound(arr)
- dic(arr(i, 2)) = arr(i, 1)
- Next
- With Sheets("原始数据")
- irow = .Cells(Rows.Count, "A").End(xlUp).Row
- arr = .Range("a1:a" & irow)
- ReDim AR(1 To irow)
- For i = 1 To UBound(arr)
- If dic.exists(arr(i, 1)) Then
- AR(i) = dic(arr(i, 1))
- End If
- Next
- .Range("b1").Resize(irow, 1) = Application.Transpose(AR)
- End With
- Set dic = Nothing
- End Sub
复制代码 看看符合要求吗 |
|