|
发表于 2014-3-15 17:35
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr, rng As Range, i&, k&, j%
- arr = Sheet2.Range("a1").CurrentRegion
- Sheet1.Activate
- brr = ActiveSheet.UsedRange
- For i = 1 To UBound(brr)
- For j = 1 To UBound(brr, 2)
- For k = 1 To UBound(arr)
- If brr(i, j) Like "*" & arr(k, 1) & "*" Then
- If rng Is Nothing Then Set rng = Cells(i, 1) Else Set rng = Union(rng, Cells(i, 1))
- GoTo line1
- End If
- Next
- Next
- line1:
- Next
- If Not rng Is Nothing Then rng.EntireRow.Delete
- End Sub
复制代码 |
|