|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- Dim r%, i%
- Dim arr, brr
- Dim d(1 To 2) As Object
- For i = 1 To 2
- Set d(i) = CreateObject("scripting.dictionary")
- Next
- With Worksheets("完成")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = Application.Max(.Cells(.Rows.Count, 1).End(xlUp).Row, .Cells(.Rows.Count, 2).End(xlUp).Row)
- arr = .Range("a2:b" & r)
- For j = 1 To 2
- For i = 1 To UBound(arr)
- d(j)(arr(i, j)) = ""
- Next
- Next
- End With
- With Worksheets("花名册")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("a2:b" & r)
- ReDim brr(1 To UBound(arr), 1 To 2)
- For j = 1 To 2
- m = 0
- For i = 1 To UBound(arr)
- If Not d(j).exists(arr(i, 1)) Then
- m = m + 1
- brr(m, j) = arr(i, 1)
- End If
- Next
- Next
- End With
- With Worksheets("没完成")
- .UsedRange.Offset(1, 0).ClearContents
- .Range("a2").Resize(UBound(brr), UBound(brr, 2)) = brr
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|