- Sub x()
- Dim k1, k2, x, y, r, a, b, s, c()
- k1 = Val(Split(Split([c5], "=")(0), "-")(0))
- k2 = Val(Split(Split([c5], "=")(0), "-")(1))
- a = Split(Split([c5], "=")(1), " ")
- b = Range("b5:b" & [b65536].End(3).Row)
- For x = 1 To UBound(b)
- For y = 0 To UBound(a)
- If InStr(b(x, 1), a(y)) Then s = s + 1
- Next
- If s <= k2 And s >= k1 Then
- r = r + 1
- ReDim Preserve c(1 To 1, 1 To r)
- c(1, r) = b(x, 1)
- End If
- s = 0
- Next
- [f:f].Clear
- [f5].Resize(r) = Application.Transpose(c)
- End Sub
复制代码 |