I should have said to start in cell D1 or somewhere in row 1

"Bob Umlas, Excel MVP" wrote:

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!

"Bob Phillips" wrote:

It works fine for me, although it should be RC for the activecell, not RC1,
as that gets column A (always).

--
HTH

Bob

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

"Abdul" wrote in message
ups.com...
Hi,
When I recorded a macro under 2007 I got he following :

Selection.FormulaArray =
"=SUM(IF(MONTH(Dt_07)=MONTH(RC1),TotSal07,0))"

by RC1 I am trying to reference Current Row Column 1 (which was
working fine under 2003)

How I do this under 2007, since RC1 is referencing to Cell RC1 (I
think) under 2007

Thanks