See "the R1C1 reference style" in XL Help.



In article ,
(Charlie) wrote:

I thought I read somewhere that there was a relative
cell reference, something like R[1]C[1] which would refer to the cell
one column to the right and one row down, or RC[-1] which would refer
to the cell pn the same row and ne column to the left. But I can't get
this to work or an more information on it.