Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Whats the significance of 'RC' (Excel 2000 >)

    In <post:=428,760>post 428,760</post:> and <post:=540,603>post 540,603</post:> there is a reference to the =GET.CELL(48,INDIRECT("RC",FALSE)) formula that is set up as a range name, and used to shade formulas in the sheet as a different colour.

    I used this the other day again, but still want to find out if anyone understands the significance of "RC"? It is obviously refering to Row/Column, but how does the INDIRECT formula know this? If I change "RC" in the formula to "AB", the cells do not highlight, if I change it to "R", some formulas highlight and others not. Nothing happens if I just use "C"? Then again it works if I use "RC"...but not if I use "CR"....

    Any explanation for these initials?

    Tx
    Regards,
    Rudi

  2. The Following User Says Thank You to Rudi For This Useful Post:

    JohnS0603 (2015-08-15)

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Whats the significance of 'RC' (Excel 2000 >)

    The 2nd argument of INDIRECT specifies whether the first argument is an A1 style reference. Since it is FALSE here, it is an R1C1 style reference. RC refers to the current row and column, i.e. to the active cell.

  4. The Following User Says Thank You to HansV For This Useful Post:

    JohnS0603 (2015-08-15)

  5. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Whats the significance of 'RC' (Excel 2000 >)

    OK...thank you Hans...now this makes sense!
    BIG <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

  6. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Whats the significance of 'RC' (Excel 2000 >)

    As an addition: if you had wanted to refer to the cell below the active cell, you could have used "R[1]C", and if you had wanted to refer to the cell two columns to the right of the active cell, you could have used "RC[2]".
    If you omit the square brackets, you refer to an absolute cell address: "R3C2" corresponds to the cell in the 3rd row and 2nd column, i.e. cell B3.
    And for example "R1C" refers to the cell in row 1 in the same column as the active cell.

  7. The Following User Says Thank You to HansV For This Useful Post:

    JohnS0603 (2015-08-15)

  8. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Whats the significance of 'RC' (Excel 2000 >)

    So "RC" is then absolutely relative - <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Thx for the addition. I use this R1C1 notation in VBA here and there, and its good to get a reminder of the absolute/relative mixes of this notation.

    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •