|
发表于 2015-3-3 11:08
|
显示全部楼层
本楼为最佳答案
- Sub 查找()
- arr = [a1].CurrentRegion
- mr = UBound(arr): mc = UBound(arr, 2)
- xm = [g1]: xsearch = [h1]
- c = [a1].Resize(1, mc).Find(xm).Column '待查找项目所在的列
- brr = arr: n = 1
- For i = 2 To mr
- If InStr(arr(i, c), xsearch) > 0 Then
- n = n + 1
- For j = 1 To mc: brr(n, j) = arr(i, j): Next
- End If
- Next
- If n > 1 Then
- [f3].Resize(mr, mc).Clear
- [f3].Resize(n, mc) = brr
- End If
- End Sub
复制代码 |
|