title: How can I solve mis-match error and correct the type?
body: <p>I am getting a </p>
  
  <blockquote>
    <p>mis-match error 13</p>
  </blockquote>
  
  <p>when trying to run my code. I think I understand what is causing it but I can't figure out how to fix it. </p>
  
  <p>The mis-match error is saying <code>RegionFcstAmt1 type is Variant/String</code> but the expression type to the right says Variant/Integer</p>
  
  <pre><code>Sub ShowUserForm1()
  
      TheAdjustment = ActiveCell.Value
      TheSubFamily = Cells(ActiveCell.Row, 1)
      Site = Cells(1, 1)
  
      UserForm1.RegionFcstAmt1.Value = Application.WorksheetFunction.IfError(Application.WorksheetFunction.SumProduct(Application.WorksheetFunction.SumIfs(Application.WorksheetFunction.Index(Sheets("REV DATA").Range("$AK:$BH"),Application.Match(ForecastDate, Sheets("REV DATA").Range("$AK$3:$BH$3"), 0)), Sheets("REV DATA").Range("$A:$A"), Sheets("TOTAL CHANGES").Range("$A6"), Sheets("REV DATA").Range("$H:$H"), TheSubFamily, Sheets("REV DATA").Range("$D:$D"), Sheets("TOTAL CHANGES").Range("$C6"), Sheets("REV DATA").Range("$E:$E"), Sheets("TOTAL CHANGES").Range("$D6:$F6"))), 0)
  
      UserForm1.Show
  
  End Sub
  </code></pre>