Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check for NON-presence of a string in another string | Excel Worksheet Functions | |||
how to I make member list that indicates when subs due | Excel Worksheet Functions | |||
Macro syntax to check string length in a cell | Excel Discussion (Misc queries) | |||
How do I put each member of string concatenation in its own line? | Excel Worksheet Functions | |||
Cell is a Member of a range or Not | Excel Programming |