title: entering a VBA array formula that is too long
body: <p>Hi I'm trying to insert a formula array this way </p>
  
  <pre><code>Dim F1 As String
  Dim f2 As String
  
  F1 = "=SUM(--(FREQUENCY(IF(rptEURegThresholds!C[7]=""Yes"",IF(rptEURegThresholds!C[16]=""No"",IF(rptEURegThresholds!C[15]=""Total Disclosure"",1,1"
  f2 = "MATCH(rptEURegThresholds!C[-1],rptEURegThresholds!C[-1],0)))),ROW(rptEURegThresholds!C[-1])-ROW(rptEURegThresholds!R[-6]C[-1])+1)&gt;0))"
  
  With sh8.Range("F7")
      .FormulaArray = F1
      .Replace "1,1", f2, xlPart
  End With
  </code></pre>
  
  <p>But something is wrong and can't find the issue. Please help!!!</p>