Check Email Addresses with Excel #excelshorts #excel #vbaprogramming

Check Email Addresses with Excel
This function checks if a value is a valid email address against certain 2-letter country or region codes and top-level domains including.

Just copy the VBA code to your workbook.
Function IsEmail(email As String) As Boolean
Dim RegEx As Object
Set RegEx = CreateObject("VBScript.RegExp")
RegEx.Pattern = "^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,}$"
RegEx.IgnoreCase = True
IsEmail = RegEx.Test(email)
End Function

'Excel Explained: Basics' Playlist: