|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
参与一下,字典+数组法- Sub ykcbf() '//2024.3.14
- Application.ScreenUpdating = False
- Set d = CreateObject("Scripting.Dictionary")
- Set sh = ThisWorkbook.Sheets("Sheet1")
- p = ThisWorkbook.Path
- f = p & "\公司员工总表 .xlsx"
- Set wb = Workbooks.Open(f, 0)
- With wb.Sheets(1)
- arr = .UsedRange
- wb.Close False
- End With
- For i = 2 To UBound(arr)
- s = CStr(arr(i, 3))
- d(s) = arr(i, 4)
- Next
- With sh
- r = .Cells(Rows.Count, 3).End(3).Row
- arr = .Range("a1").Resize(r, 4)
- For i = 2 To UBound(arr)
- s = CStr(arr(i, 3))
- arr(i, 4) = d(s)
- Next
- .Range("a1").Resize(r, 4) = arr
- End With
- Set d = Nothing
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|