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