|
发表于 2016-11-2 09:08
|
显示全部楼层
本楼为最佳答案
Sub mySearch()
Dim A, i, j, k, str
A = Sheets(2).Range("a1").CurrentRegion
Sheets(1).Select
str = [b1]
For i = 2 To UBound(A)
If InStr(A(i, 1), str) Then
k = k + 1
For j = 1 To UBound(A, 2)
A(k, j) = A(i, j)
Next j
End If
Next i
[a2:b65536] = ""
[a2].Resize(k, UBound(A, 2)) = A
End Sub
查找2.rar
(16.88 KB, 下载次数: 5)
|
|