title: VBA - Search a string for all values in array
body: <p>Just an efficiency question here. I'm essentially looping through cells in a column to see if they contain a specific string, but then that cell also needs to not include any of 14 different strings. My current solution is to find the string, and then loop through the array using instr on the cell. However, this will happen possibly hundreds of times when the macro is running. I'm curious if there is a better way.</p>
  
  <p>For instance:</p>
  
  <pre><code>NotArr = Array("blah1", "blah2", "blah3", "etc")
  
  For r = 1 to 10
      'Let's assume I've already found the first string
      For i = 1 to 4
          If Not InStr(Cells(r, 1).value, NotArr(i)) &gt; 0 Then
              'Do things
          End If
      Next i
  Next r
  </code></pre>
  
  <p>Note: I know I'm probably overthinking or just missing the obvious. I've been buried in VBA for about 6 weeks @ 10 hour days and can feel my brain melting.</p>
  
  <p>Thanks all!</p>