title: Return Index of an Element in an Array Excel VBA
body: <p>I have an array prLst that is a list of integers. The integers are not sorted, because their position in the array represents a particular column on a spreadsheet.  I want to know how I find a particular integer in the array, and return its index.  </p>
  
  <p>There does not seem to be any resource on showing me how without turning the array into a range on the worksheet. This seems a bit complicated.  Is this just not possible with VBA?</p>