title: How to find multiple strings in VBA
body: <p>Assume an Excel sheet contains the following values in a random column:</p>
  
  <pre><code>VARIABLE X
  AbbA
  AddA
  bbAA
  ccbb
  KaaC
  cccc
  ddbb
  ccdd
  BBaa
  ddbB
  Bbaa
  dbbd
  kdep
  mCca
  mblp
  ktxy
  </code></pre>
  
  <p>Now the column should be searched for several words and word-phrases at the same time, for example the following: </p>
  
  <p>(1) "bb" </p>
  
  <p>(2) "cc" </p>
  
  <p>(3) "d" </p>
  
  <p>I put the target strings in an array:</p>
  
  <pre><code>Dim searchFor As String
  Dim xArr 
  searchFor = "bb/cc/d"
  xArr = Split(searchFor , "/")
  </code></pre>
  
  <p>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").</p>
  
  <p>If possible, ignore the column title ("VARIABLE X) for searching/filtering as well as in the final selection of values.</p>
  
  <p>How can this be done in VBA using (1) filters and/or using (2) regular loops? Which way would you recommend?</p>