|
- Sub 筛选()
- x = [a1]
- If Len(x) > 0 Then
- arr = [a3].CurrentRegion
- brr = arr
- For i = 2 To UBound(arr)
- If arr(i, 7) Like "*" & x & "*" Then
- n = n + 1
- For j = 1 To UBound(arr, 2)
- brr(n + 1, j) = arr(i, j)
- Next
- End If
- Next
- End If
- If n > 0 Then
- With Sheet2
- .Activate
- .UsedRange.ClearContents
- .[a1].Resize(n + 1, UBound(brr, 2)) = brr
- .Columns.AutoFit
- End With
- End If
- End Sub
复制代码 |
|