|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
参与一下。。。- Sub ykcbf() '//2023.12.31
- Dim arr, brr
- Application.ScreenUpdating = False
- Set d = CreateObject("Scripting.Dictionary")
- Set sh = ThisWorkbook.Sheets("Sheet2")
- With Sheet1
- r = .Cells(Rows.Count, 4).End(3).Row
- arr = .Range("D1:e" & r)
- End With
- For i = 1 To UBound(arr)
- d(CStr(arr(i, 2))) = arr(i, 1)
- Next i
- b = Split(Sheet2.[DG6], ",")
- ReDim brr(1 To UBound(b) + 1, 1 To 2)
- For i = 0 To UBound(b)
- m = m + 1
- brr(m, 1) = d(b(i))
- brr(m, 2) = b(i)
- Next i
- With sh
- .Columns("DL:DP").Clear
- .[DL1].Resize(UBound(brr), 2) = brr
- End With
- Set d = Nothing
- Application.ScreenUpdating = True
- Beep
- End Sub
复制代码
|
|