Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make XL stop interpreting email addresses as highlighted links? | Excel Discussion (Misc queries) | |||
import email addresses into an excell list | New Users to Excel | |||
Change email addresses | Excel Discussion (Misc queries) | |||
copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) |