ExcelBanter - emails

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - emails (https://www.excelbanter.com/excel-discussion-misc-queries/78439-emails.html)

al1776

emails

how do I test emails in excel to see if they are valid.

Ron de Bruin

emails

hi al1776

I use this in my code to test the cell value
If cell.Value Like "?*@?*.?*"

But you are not sure they really exist

--
Regards Ron de Bruin
http://www.rondebruin.nl

"al1776" wrote in message ...
how do I test emails in excel to see if they are valid.

All times are GMT +1. The time now is 10:49 PM.