Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Verify email
I have names and email addresses in excel worksheet...is there a way to
validate these addresses |
#2
|
|||
|
|||
Hi Sandee
Do you want this? You can check for the @ and the . character in each mail address Sub test() ' J.E suggestion "?*@?*.?*" instead of *@* For Each mycell In Columns("B").Cells.SpecialCells(xlCellTypeConstant s) If mycell.Value Like "?*@?*.?*" Then 'do nothing Else MsgBox "Wrong E-mail address in " & mycell.Address End If Next End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Sandee" wrote in message ... I have names and email addresses in excel worksheet...is there a way to validate these addresses |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activate email column to hyperlinks | Excel Discussion (Misc queries) | |||
background color showing only when in email form | Excel Discussion (Misc queries) | |||
Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
Shut off email address from linking to email program? | Excel Worksheet Functions | |||
How do I include cell data in subject line of email address/hyperl | Excel Worksheet Functions |