|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 lsc900707 于 2018-4-25 14:46 编辑
你不是一个大包吗?怎么发个小包呢?
Sub gj23w98()
Set wb = GetObject(ThisWorkbook.Path & "\" & "数据.xlsx")
Set d = CreateObject("scripting.dictionary")
With wb
For k = 1 To .Sheets.Count
arr = .Sheets(k).[a1].CurrentRegion
For i = 2 To UBound(arr)
s = arr(i, 1) & arr(1, 2)
d(s) = arr(i, 2)
Next
Next
End With
brr = [a1].CurrentRegion
For i = 2 To UBound(brr)
For j = 2 To UBound(brr, 2)
s = brr(i, 1) & brr(1, j)
brr(i, j) = d(s)
Next
Next
[a1].CurrentRegion = brr
Set wb = Nothing
Set d = Nothing
End Sub
|
评分
-
1
查看全部评分
-
|