ExcelBanter - Array formulas into VB programming

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

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

- - Array formulas into VB programming (https://www.excelbanter.com/excel-programming/275553-array-formulas-into-vbulletin-programming.html)

Angelo Battistoni

Array formulas into VB programming

Good day!

I need to put this array formula "{=SUM(IF(DAT2="WA",ABS(DAT8),0))}" into a
cell in Excel using VB programing how do I do that?

Please Please Help

P.S. Thank you in Advance

Tom Ogilvy

Array formulas into VB programming

Range("A1").formulaArray = ""{=SUM(IF(DAT2=""WA"",ABS(DAT8),0))"

--
Regards,
Tom Ogilvy

"Angelo Battistoni" wrote in message
...
Good day!

I need to put this array formula "{=SUM(IF(DAT2="WA",ABS(DAT8),0))}" into
a
cell in Excel using VB programing how do I do that?

Please Please Help

P.S. Thank you in Advance

Alan Beban[_3_]

Array formulas into VB programming

There's a typographically erroneous extraneous "{ in the formula.

Alan Beban

Tom Ogilvy wrote:
Range("A1").formulaArray = ""{=SUM(IF(DAT2=""WA"",ABS(DAT8),0))"

Tom Ogilvy

Array formulas into VB programming

Range("A1").formulaArray = "=SUM(IF(DAT2=""WA"",ABS(DAT8),0))"

would be the correction.

--
Regards,
Tom Ogilvy

"Alan Beban" wrote in message
...
There's a typographically erroneous extraneous "{ in the formula.

Alan Beban

Tom Ogilvy wrote:
Range("A1").formulaArray = ""{=SUM(IF(DAT2=""WA"",ABS(DAT8),0))"

All times are GMT +1. The time now is 05:06 PM.