|
本帖最后由 从从容容 于 2012-7-26 22:56 编辑
- Sub aa1()
- Dim a As Long
- Dim b As Long
- Dim arr, arry
- Dim rag As Range
- arr = Sheets("sheet1").Range("a1:a" & Sheets("sheet1").[a65536].End(xlUp).Row)
- arry = Sheets("续期").Range("p2:p" & Sheets("续期").[p65536].End(xlUp).Row)
- For a = 1 To UBound(arry, 1)
- For b = 1 To UBound(arr, 1)
- If arry(a, 1) = arr(b, 1) Then
- If rag Is Nothing Then
- Set rag = Sheets("续期").Range("p" & a + 1)
- Else
- Set rag = Union(rag, Sheets("续期").Range("p" & a + 1))
- End If
- End If
- Next
- Next
- rag.EntireRow.Delete
- End Sub
复制代码 我这个会更快些。 |
评分
-
查看全部评分
|