title: Getting Type mismatch Error in VBA
body: <p>I have a code, something like this :</p>
  
  <pre><code>Public Sub Match()
  
      ThisWorkbook.Sheets("Sheet1").Activate
  
      Range("Data!H8") = Application.Sum(Application.Index(Range("A:GH"), 0, Application.Match("ORDERS" &amp; "Country", Range("B2:B100") &amp; Range("A2:GH2"), 0)))
  
  End Sub
  </code></pre>
  
  <p>When I run this code I'm getting a error "Type Mismatch". Can anybody help me with this?
  <a href="https://i.stack.imgur.com/HSC77.png" rel="nofollow noreferrer">enter image description here</a></p>