check to see if cell contains a string = to member of list
I can't seem to find a reference to doing this. Perhaps someone could help
me.
I have a customer list that includes educational institutions. The name may
include the word "school" or "college" or "university" and a bunch of
others. I am using a macro to copy my customer list from one worksheet to
the next. If the cell containing the names of the customers (column A)
includes one of the above strings, I want to skip on to the next row and not
copy that row.
My initial thought was that there might be some function to check if a cell
contained any of my words (that had been defined as part of an array,
perhaps) but I can't seem to find an efficient way of doing this.
Any suggestions?
Thanks again.
|