Macro to show message on invalid format by checking if filled for dynamic range

[coolguyvarun01]

Hi Experts,


I was given a task wherein I have to write a macro on email to check if the format is anything@anything.anything
for a complete column when value is entered in that cell ,blanks are allowed. now data can be in rows 1,2,3,7,9....
Kindly help.

[TABLE="width: 212"]
<tbody>[TR]
[TD]Operation[/TD]
[TD]name[/TD]
[TD]email[/TD]
[/TR]
[TR]
[TD]Create[/TD]
[TD]ABC[/TD]
[TD]abc[/TD]
[/TR]
[TR]
[TD]Create[/TD]
[TD]BCD[/TD]
[TD]ab@c.com[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]change[/TD]
[TD]sfdsf[/TD]
[TD]abc@y.com[/TD]
[/TR]
</tbody>[/TABLE]


p.s.: already data validation is there to check if user is entering value before choosing the operation