| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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))" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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))" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| Array Formulas | Excel Worksheet Functions | |||
| array formulas using MIN MAX | Excel Worksheet Functions | |||
Linear Mode
