N
Niklas
Hi
I have read everything I have found in MSDN after a search
on FormulaArray, but I still do not know what it is used
for. This is an example from MSDN:
Worksheets("Sheet1").Range("E1:E3").FormulaArray = "=Sum
(R1C1:R3C3)"
but what is the differance between FormulaArray and
Formula:
Worksheets("Sheet1").Range("E1:E3").Formula = "=Sum
(R1C1:R3C3)"
According to me they produce the same result. Can someone
explain the differnace and when I am supposed to use
FormulaArray?
Best regards
/Niklas
I have read everything I have found in MSDN after a search
on FormulaArray, but I still do not know what it is used
for. This is an example from MSDN:
Worksheets("Sheet1").Range("E1:E3").FormulaArray = "=Sum
(R1C1:R3C3)"
but what is the differance between FormulaArray and
Formula:
Worksheets("Sheet1").Range("E1:E3").Formula = "=Sum
(R1C1:R3C3)"
According to me they produce the same result. Can someone
explain the differnace and when I am supposed to use
FormulaArray?
Best regards
/Niklas