In both XL2003 and XL2007, I get
Selection.FormulaArray = "=SUM(RC[-3])"
When I run the macros they give ={SUM(A1)}
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Abdul" wrote in message
oups.com...
This is from an earlier post

Start in cell D1 or somewhere in row 1
Record this:
Array-enter =SUM($A1)
What gets recorded is
Selection.FormulaArray = "=SUM(RC1)"
Play it back.
What gets entered is the array-entered
=SUM(RC1)
INTERESTING!

Do any one have a solution ? probably any big fix in Excel 2007?

Thanks,

Abdul