Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding
Why do the cell references in part of the macro below
include negative numbers? ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-3]" Range("C5").Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding
The cells are reference as R1, C1 - It's like offset from the activecell.
ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-3]" This could also be interpreted as this ActiveCell.Formula = "=B2+B3" If you want to see this type of refernce on your worksheet, goto menu bar TOOLS Options Click the General tab, you will see the R1C1 reference style. This type is useful, when you want to calculate / move to cells based on your current location. Hope this helps Hari "Eléna" wrote in message ... Why do the cell references in part of the macro below include negative numbers? ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-3]" Range("C5").Select --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.746 / Virus Database: 498 - Release Date: 31/08/2004 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding
The interpretation would depend on what cell the formula is place in, but
since the rows are absolute and the columns relative, I don't know of any cell where it would be interpreted as =B2+B3, particularly since the formula does subtraction rather than addition ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-3]" if the activeCell is D5 would be equivalent to =B5-A5 -- Regards, Tom Ogilvy "Harry" wrote in message ... The cells are reference as R1, C1 - It's like offset from the activecell. ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-3]" This could also be interpreted as this ActiveCell.Formula = "=B2+B3" If you want to see this type of refernce on your worksheet, goto menu bar TOOLS Options Click the General tab, you will see the R1C1 reference style. This type is useful, when you want to calculate / move to cells based on your current location. Hope this helps Hari "Eléna" wrote in message ... Why do the cell references in part of the macro below include negative numbers? ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-3]" Range("C5").Select --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.746 / Virus Database: 498 - Release Date: 31/08/2004 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding
hi
In the example below, R stands for Row and C stands for column. Positive number For R mean down negative number mean up. Positive number for c mean left negative number mean right so RC[-2] means zero rows up/down and 2 columns to left. if R[1]C[2] then one row down and 2 column right. -----Original Message----- Why do the cell references in part of the macro below include negative numbers? ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-3]" Range("C5").Select . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum by coding without 0 | New Users to Excel | |||
sum by coding | New Users to Excel | |||
coding | Excel Discussion (Misc queries) | |||
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? | Excel Programming | |||
Coding | Excel Programming |