Array formulas into VB programming

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
 
T

Tom Ogilvy

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

would be the correction.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
How to read Excel Array to vb.net Arrays? 20
Use a listbox as a dynamic array? 9
Put Formula in VBA 1
Array to Multiple Arrays 3
Password Cracker for Excel Worksheets/ Workbooks 9
Array with excel sheet inside (need 2 code rows please) 3
Array Formulas + VB Code 2

Top