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