View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Verifying Email addresses etc using macros

I get this Excel sheet everyday which contains email addresses,
sometimes even 10000 rows in each. I would like to run a macro that
verifies the email address format (*@*.*) and verifies that it has no
spaces or no blank rows. There are other columns too in the sheet,
where I need to verify that none of the rows in those columns are
empty.
I have never written macros before, please help.

Thanks in advance !