Row and Column Reference 2007

Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Excel - changing reference column value based on another column	Dharmesh Patel[_2_]	Excel Discussion (Misc queries)	2	October 12th 09 01:19 PM
How to make an absolute reference to an excel 2007 table column	Ollie4	Excel Discussion (Misc queries)	1	February 6th 08 07:13 PM
Column letter reference as number reference	mcphc	Excel Programming	8	January 30th 07 03:06 PM
Row reference increment but preserve column reference	Pwanda	Excel Worksheet Functions	1	April 28th 05 01:12 PM
Macro to Reference Column Next to Current Reference	dolphinv4	Excel Discussion (Misc queries)	2	April 11th 05 08:36 AM

All times are GMT +1. The time now is 11:48 PM.

Menu

About Us