Assume an Excel sheet contains the following values in a random column:
VARIABLE X AbbA AddA bbAA ccbb KaaC cccc ddbb ccdd BBaa ddbB Bbaa dbbd kdep mCca mblp ktxy
Now the column should be searched for several words and word-phrases at the same time, for example the following:
I put the target strings in an array:
Dim searchFor As String Dim xArr searchFor = "bb/cc/d" xArr = Split(searchFor , "/")
Also assume it does not matter if "bb" is in small letters or big letters (not case sensitive in this case). For the other cases it is case sensitive. At the end I would like to select the respective target cases in terms of their associated rows. Please also note that I would like to include cases in the selection, where the target string (e.g. "bb") is part of a word (e.g. "dbbd").
If possible, ignore the column title ("VARIABLE X) for searching/filtering as well as in the final selection of values.
How can this be done in VBA using (1) filters and/or using (2) regular loops? Which way would you recommend?