Edit A Line to Include Variations

[pcargila]

Hey guys,

How would I edit the line

Please Login or Register  to view this content.

to include more than one value?

I have variations of "Public Relations" that include "Public relations;Attorneys" etc. and they get deleted when I run my macro..

Please Login or Register  to view this content.

I know its probably something simple, but I'm still pretty lost when it comes to this stuff..

Thanks in advance

[piyushdabomb]

Replace the following line:

Please Login or Register  to view this content.

with this one instead:

Please Login or Register  to view this content.

That will ignore anything with "Public relations" in it.

You should optimize your code by using the find function and find all values where 'public relations' is found partly. Learn it up.

[shg]

It depends on exactly what the criteria is. If the words must be contained in the text in any case (upper, lower, mixed), then

Please Login or Register  to view this content.

[mikerickson]

You might use the Like comparison

Please Login or Register  to view this content.

which will not delete "Public Relation Department", "Public relations expert" "PublicRelations typo" and other variations.

[pcargila]

Thanks for all your help guys, it works great!