|
发表于 2016-12-16 13:53
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim arr, i&, j&
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("数据源").[a1].CurrentRegion.Offset(1, 0).value
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 1)
- If arr(i, j) = Sheets("高级查询").[b1].value Then
- d(i) = ""
- End If
- Next
- Next
- Application.ScreenUpdating = False
- For Each Key In d.keys
- Sheets("数据源").[a1].CurrentRegion.Rows(Key + 1).Copy Sheets("高级查询").[a1].End(4).Offset(1, 0)
- Next
- Sheets("高级查询").[a1].CurrentRegion.Borders.LineStyle = 1
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|