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.