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
.