A Simple Email Validation Question

I have a column full of email addresses and I have been trying to create a macro that simply makes sure each address at least has an @ and . in it to eliminate the number of emails that bounce back.

I would prefer the macro to either check the range I highlighted or even the specific column since it will always be column A.

Also it would be ideal if it simply just highlighted the invalid emails. I was hoping this would be an easy fix for macro gurus.

After getting on the Internet and trying to learn VB and macros, below is what I have but its not working and it is using a message box instead of highlighting since I am not sure how to do that.

Please Login or Register  to view this content.

Thanks for any help and tips.

Hello cfaust,

Welcome to the Forum!

This macro will highlight any invalid email addresses in column "A" start with cell "A2". I am assuming you have a header in in "A1".

Please Login or Register  to view this content.

Hello cfaust,

If only I could type. Remove one of the "Like" statements in the line.

Please Login or Register  to view this content.