title: Concat multiple MATCH criteria in Excel VBA
body: <p>So in Excel, we know it's possible to test against multiple criteria via concatenation, like this:</p>
  
  <pre><code>MATCH(criteria1&amp;criteria2, Range(), 0)
  </code></pre>
  
  <p>where <code>criteria1</code> and <code>criteria2</code> are 2 separate criteria.</p>
  
  <p>I'm trying to automate this thing in Excel VBA, like this:</p>
  
  <pre><code>WorksheetFunction.Match(criteria1 + "&amp;" + criteria2, Range(), 0)
  </code></pre>
  
  <p>My question is, how do I replicate the same concatenation of criteria with the ampersand, in VBA form? In the version above, Excel keeps telling me it can't use the Match function of the WorkSheetFunction class, which I'm attributing to the failed concatenation attempt above. Any suggestions or advice would be greatly appreciated.</p>
  
  <p>Oh, and here's a link to a Microsoft Knowledge Base article about using multiple criteria in <code>MATCH()</code>: <a href="http://support.microsoft.com/kb/59482" rel="nofollow">http://support.microsoft.com/kb/59482</a></p>
  
  <p>EDIT: I realized I wasn't putting 2 ranges to correspond with my 2 criteria. The problem is I don't know how to concatenate 2 ranges, because mine are in the form:</p>
  
  <pre><code>Range(Cells(1,columnIndex),Cells(rowCount,columnIndex))
  </code></pre>
  
  <p>as opposed to <code>A1:A200</code>. Any ideas on how to convert, or to concat the ranges in their current form?</p>