title: Using 'Contains' on an Array
body: <p>Ok, so I'm not very familiar with VB6 but I'm trying to see if an array contains a value. This is what I have but it's throwing up an error to me. Could be an issue with the "passedValue" being the wrong type but I don't think so.  </p>
  
  <pre><code>    Dim transCodes As Variant
      transCodes = Array(40, 41, 42, 43)
      If (transCodes.Contains("passedValue")) Then
      *Do Stuff*
      End If
  </code></pre>
  
  <p>Any help would be really appreciated!</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>Failing correcting my syntax, could you give me an example for the cast/convert I might use to ensure the "passedValue" was of the right type?</p>
  
  <p><strong>UPDATING MY UPDATE</strong></p>
  
  <p>So is there no 'Contains' method in VB6? Any other ways of doing this simple task?</p>