|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 按钮1_Click()
- Set d = CreateObject("scripting.dictionary")
- Application.ScreenUpdating = False
- arr = ActiveSheet.UsedRange
- For j = 2 To UBound(arr)
- d(arr(j, 3)) = j
- Next j
- If Dir(ThisWorkbook.Path & "\BB.xlsx") <> "" Then
- With Workbooks.Open(ThisWorkbook.Path & "\BB.xlsx")
- brr = .Sheets(1).UsedRange
- For j = 3 To UBound(brr)
- If d.exists(brr(j, 1)) Then
- r = d(brr(j, 1))
- For i = 1 To 4
- ThisWorkbook.Sheets(i).Cells(r, 6) = brr(j, i + 1)
- Next i
- End If
- Next j
- .Close False
- End With
- End If
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|