I am trying to delete entire rows that have the words "admin" "sales" and "support" as part of their email addresses in column B. Could somebody help me out please?
Thank you
I am trying to delete entire rows that have the words "admin" "sales" and "support" as part of their email addresses in column B. Could somebody help me out please?
Thank you
Make a macro that will loop thru all lines and if it find the words in the phrase just (assuming i is your line number)
Please Login or Register to view this content.
"The quieter you become, the more you are able to hear"
Any reputation (*) points appreciated.
"If you know yourself but not the enemy, for every victory gained, you will suffer defeat."
Try:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks