Row and Column Reference 2007

[Abdul]

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

 

[Bob Phillips]

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)

 

[Bob Umlas, Excel MVP]

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]

Not for me it doesn't. You guys must have some setting.

--
HTH

Bob

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

 

[Abdul]

Thnaks Bob,

I am trying to reference Column A current Row.

But I run the code instead of having Month($A10) - as in my case- it
shows Month(RC1)


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

The above supposed to look like

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

????!!!!!

Thnaks

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!

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

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

"Abdul" <[email protected]> wrote in message

 

[Bob Phillips]

As I said Abdul, I cannot replicate the problem, but apparently Bob Umlas
can.

--
HTH

Bob

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

 

[Bob Umlas, Excel MVP]

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