|
发表于 2017-5-30 13:48
|
显示全部楼层
本楼为最佳答案
试试!{:1612:}
- Sub test()
- Dim d As Object
- Dim ar, br
- Dim i As Long
- Set d = CreateObject("scripting.dictionary")
- ar = Range("A3:A" & Cells(Rows.Count, 1).End(3).Row)
- br = Range("C3:C" & Cells(Rows.Count, 1).End(3).Row)
- For i = 1 To UBound(br)
- If Not d.exists(br(i, 1)) Then d.Add br(i, 1), ""
- Next i
- For i = 1 To UBound(ar)
- If d.exists(ar(i, 1)) Then
- j = j + 1
- ar(j, 1) = ar(i, 1)
- End If
- Next i
- With Cells(3, 5)
- .Resize(Rows.Count - 2).ClearContents
- If j > 0 Then .Resize(j) = ar
- End With
- End Sub
复制代码
|
|