Try something like

Worksheets("Sheet2").Range("E1:E3").Formula = "=TRANSPOSE(F1:H1)"

and

Worksheets("Sheet2").Range("E1:E3").FormulaArray = "=TRANSPOSE(F1:H1)"

to see an illustration of the difference.

Alan Beban

Niklas wrote:
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