2,464
社区成员
发帖
与我相关
我的任务
分享
条件=IF(IFERROR(FIND("a",test),0)+IFERROR(FIND("b",test),0)+IFERROR(FIND("c",test),0)>0,FALSE,TRUE),然后用高级筛选
Option Explicit
'如果strVal字符串内包含arrKeywords字符串数组中的任意一项,返回False,否则返回True.
Public Function IsKeywordsExcluded(ByVal strVal As String, ParamArray arrKeywords()) As Boolean
Dim i As Integer
For i = LBound(arrKeywords) To UBound(arrKeywords)
If InStr(arrKeywords(i), strVal) > 0 Then
IsKeywordsExcluded = False
Exit Function
End If
Next
IsKeywordsExcluded = True
End Function
Sub Macro3()
'
' Macro3 Macro
'
'
Range("A1:A27").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"C1:C2"), CopyToRange:=Range("I1"), Unique:=False
End Sub