Row and Column Reference 2007
 

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

Row and Column Reference 2007
 

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

Row and Column Reference 2007
 

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

Row and Column Reference 2007
 

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)

"Bob Umlas, Excel MVP" wrote in
message ...
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

Row and Column Reference 2007
 

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


On Aug 13, 6:04 pm, 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


oups.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

Row and Column Reference 2007
 

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)

"Abdul" wrote in message
oups.com...
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


On Aug 13, 6:04 pm, 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


oups.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

Row and Column Reference 2007
 

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