As mentioned in a previous post


Select D1

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!

instead of showing {=SUM($A1)} It shows {=SUM(RC1)}

Any body having this problem under 2007?

I could not get this work under 2007

Thanks

Abdul