close

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 !

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()