In Excel 2007, I get

{=SUM(RC1)}

In Excel 2003, I get

{=SUM($A1)}

Of course in Excel2003 RC1 could not be mistaken for a cell address, but still this seems to be wrong

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Bernard Liengme" wrote in message ...
| 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
|
|
|