|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
这是你需要的吧
Sub test()
Dim i, n, arr, j, brr
Dim dic
Set dic = CreateObject("scripting.dictionary")
With Workbooks.Open(ThisWorkbook.Path & "\编码表.xlsx")
arr = .Sheets(1).UsedRange
.Close False
End With
For i = 1 To UBound(arr)
dic(arr(i, 1)) = arr(i, 2)
Next
With Sheet1
brr = .UsedRange
For j = 1 To 3 Step 2
For i = 2 To .Cells(Rows.Count, 1).End(3).Row
If dic.exists(brr(i, j)) Then
brr(i, j) = arr(i, j)
End If
Next
Next
.Cells(22, 1).Resize(UBound(brr), UBound(brr, 2)) = brr
End With
End Sub |
|