Formula R1C1

[Blobajob88]

Hi,

Can anyone break this line of code down for me:

Range("A" & Cells.Rows.Count).End(xlUp).Offset(1, 9).Select
activecell.FormulaR1C1 = _
"=SUBSTITUTE(IF((IFERROR(VLOOKUP(RC[-5],[Methodology.xlsm]DATA!R1320C[-8]:R1576C[-8],1,FALSE),""""))<>"""",VLOOKUP(RC[-5],[Methodology.xlsm]DATA!R1220C[-8]:R1576C[-8],1,FALSE),""""),""-"",""_"")"
Selection.AutoFill Destination:=Range(activecell, Range("I2")), Type:=xlFillDefault

Especially the R1220C..:R1576C part

Thanks

Ben

 

[RoryA]

R1220 = Row 1220.
C[-8] means the column 8 to the left of the formula cell.
Similarly:
R1576 = Row 1576
C[-8] = 8 columns to the left. So in A1 style that would be A1220:A1576