| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Excel - changing reference column value based on another column | Excel Discussion (Misc queries) | |||
| How to make an absolute reference to an excel 2007 table column | Excel Discussion (Misc queries) | |||
| Column letter reference as number reference | Excel Programming | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
| Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) | |||
![Abdul[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
