ExcelBanter - Code for Array formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Code for Array formula (https://www.excelbanter.com/excel-programming/323748-code-array-formula.html)

Annette[_5_]

Code for Array formula

I have this formula that I'm trying to put in code, but is not reading
properly to show it is an array ... how would I add the array to handle that
part of the formula?

my code:

Worksheets("Sheet2").Range("b3").Formula = _

"=SUM((Sheet1!B2:B250=""WARRANT"")*(Sheet1!F2:F250 =""E"")*(Sheet1!C2:C250))"

Annette[_5_]

Code for Array formula

I found it ... I needed to add Array after the word formula ...
Worksheets("Sheet2").Range("b3").FormulaARRAY = _

"Annette" wrote in message
...
I have this formula that I'm trying to put in code, but is not reading
properly to show it is an array ... how would I add the array to handle
that
part of the formula?

my code:

Worksheets("Sheet2").Range("b3").Formula = _

"=SUM((Sheet1!B2:B250=""WARRANT"")*(Sheet1!F2:F250 =""E"")*(Sheet1!C2:C250))"

All times are GMT +1. The time now is 01:25 PM.