Array formulas into VB programming

  • Thread starter Thread starter Angelo Battistoni
  • Start date Start date
A

Angelo Battistoni

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
 
Range("A1").formulaArray = "=SUM(IF(DAT2=""WA"",ABS(DAT8),0))"

would be the correction.
 
Back
Top