Guest User

Untitled

a guest
Sep 18th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. Dim RegEx As Object
  2. Set RegEx = CreateObject("VBScript.RegExp")
  3. RegEx.Global = True
  4. RegEx.Pattern = strPattern
  5.  
  6. If RegEx.Replace(objCell.Value, "") = objCell.Value Then
  7. RegExCheck = 0
  8. Else
  9. RegExCheck = 1
  10. End If
  11.  
  12. =RegExCheck(A1,"[^A-Za-z0-9_-]")
Add Comment
Please, Sign In to add comment