Macro Recording 2007

[Abdul]

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

 

[Bob Phillips]

Nor I.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)