I’m trying to write a regular expression where the string matches “_Clauses” OR “_OL” but NOT “_Word”. Can anyone help? The OR part works, the NOT doesn’t.

Dim regex As Object, str As String
Set regex = CreateObject("VBScript.RegExp")

With regex
.Pattern = "_Clauses|_OL[^_Word]"
.Global = True
End With

For Each ws In ActiveWorkbook.Worksheets
str = ws.Name


Debug.Print regex.Test(str)
Next ws

Hi and welcome
please wrap code with code tags (#button) Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post