Simple Coding question

[Desu Nota from Columbus]

Can anyone please explain the R and C notation used in VB? I don't understand this:

Range("N2").Select     
ActiveCell.FormulaR1C1 = "=(RC[-5]+RC[-1])/3600"

My assumption is the the "R" is just the absolute reference marker, but I don't quite comprehend the C[+/-#] notation

 

[hiker95]

Desu Nota from Columbus,

I hope this helps.

Your code:

Range("N2").Select
ActiveCell.FormulaR1C1 = "=(RC[-5]+RC[-1])/3600"

'could also be written
Range("N2").FormulaR1C1 = "=(RC[-5]+RC[-1])/3600"

'Or
Range("N2").Formula = "=(I2+M2)/3600"

Puts the following formula into cell N2:
=(I2+M2)/3600

With N2 as the cell to accept the formula
=(RC[-5]+RC[-1])/3600

The active cell N2 formula =(I2+M2)/3600


=(RC[-5]+RC[-1])/3600

The:
(RC[-5]

says, from R (the active row = row 2) N2 offset C-5 is cell I2

The:
+RC[-1]

says, from R (the active row = row 2) N2 offset C-1 is cell M2

 

[Desu Nota from Columbus]

Thanks for the reply! Makes sense now.