Google: excel vba code to validate email address

You'll find a few functions to validate an email address. All you then need to do is loop through the range calling the macro and taking appropriate action.

Suggest you post some sample data for testing purposes if you need someone to put it together for you.


Regards, TMS