title: How to search for string in an array
body: <p>Is there an easy (one-liner) to search for a string within an array in VBA?  Or will I need to loop through each element and compare it with the target string?</p>
  
  <p>EDIT:
  It is a one-dimensional array.  I only need to know <em>IF</em> a string is somewhere in the array.</p>
  
  <p>IE:</p>
  
  <pre><code>names(JOHN, BOB, JAMES, PHLLIP)
  </code></pre>
  
  <p>How do I find out if "JOHN" is in the array, it needs to be minimal as it will be repeated around 5000 times and I don't want the function to slow the overall process down.</p>