A
Abdul
Hi All,
If I use a normal formaula in a range of cells it work properly and it
is too fast than applying a loop. But when I try the same method on an
Array formula it fails.
Like the following formula dont work. Is there a way to fis this?
Range(Range("A65536").End(xlUp).Offset(0, 1), Range("A2").Offset(0, 3))
_
.FormulaArray = "=SUM(IF(Dt=VALUE(RC1),IF(Loc=R1C,TotSal,0),0))"
Thanks
If I use a normal formaula in a range of cells it work properly and it
is too fast than applying a loop. But when I try the same method on an
Array formula it fails.
Like the following formula dont work. Is there a way to fis this?
Range(Range("A65536").End(xlUp).Offset(0, 1), Range("A2").Offset(0, 3))
_
.FormulaArray = "=SUM(IF(Dt=VALUE(RC1),IF(Loc=R1C,TotSal,0),0))"
Thanks