title: Adjusting the formula in formulaarray
body: <p>I have the following formula which i want to enter in formulaarray but am not able to do so due to size limitations.</p>
  
  <pre><code>=VLOOKUP(MIN(IF(ABS('S:\AT Reports\Abhor - Ganganagar\[1 1550 A-B.xls]1 1550 A-B'!$C$17:$C$42-B5*1000)=MIN(ABS('S:\AT Reports\Abhor - Ganganagar\[1 1550 A-B.xls]1 1550 A-B'!$C$17:$C$42-B5*1000)),IF(ABS('S:\AT Reports\Abhor - Ganganagar\[1 1550 A-B.xls]1 1550 A-B'!$C$17:$C$42-B5*1000)&lt; 500,'S:\AT Reports\Abhor - Ganganagar\[1 1550 A-B.xls]1 1550 A-B'!$C$17:$C$42,))),'S:\AT Reports\Abhor - Ganganagar\[1 1550 A-B.xls]1 1550 A-B'!$C$17:$E$42,3,FALSE)
  </code></pre>
  
  <p>What you see above is the result of the VBA program. The actual formula in the VBA code is as follows:</p>
  
  <pre><code>formulaValue = "=VLOOKUP(MIN(IF(ABS('" &amp; initpath &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B.xls]" &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B'!$C$17:$C$42-" &amp; ColToSelect &amp; "5*1000)=MIN(ABS('" &amp; initpath &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B.xls]" &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B'!$C$17:$C$42-" &amp; ColToSelect &amp; "5*1000)),IF(ABS('" &amp; initpath &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B.xls]" &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B'!$C$17:$C$42-" &amp; ColToSelect &amp; "5*1000)&lt; 500,'" &amp; initpath &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B.xls]" &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B'!$C$17:$C$42,))),'" &amp; initpath &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B.xls]" &amp; (n / 3 - 2) &amp; " " &amp; freqSheet &amp; " A-B'!$C$17:$E$42,3,FALSE)"
  
              ActiveCell.Formula = formulaValue
  </code></pre>
  
  <p>Can someone please help me with this?</p>