Seamus2626

asked on

# Reading RC convention

Hi,

Im going through other peoples code and in the editor im trying to work out what the macro is doing

One example is

=ISERROR(IF(RC[-1]="","New Item",IF(RC[-1]=RC[-42],"No","Yes")))

How do i read that RC-1 AND RC -42?

Does it mean rows/columns, what is the above doing in terms of letters?

Im going through other peoples code and in the editor im trying to work out what the macro is doing

One example is

=ISERROR(IF(RC[-1]="","New

How do i read that RC-1 AND RC -42?

Does it mean rows/columns, what is the above doing in terms of letters?

SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

Thanks guys!

On Excel 2003:

Tools / Options / General / R1C1 reference style (must be unchecked)

On Excel 2007 and 2010:

Office button / Excel Options / Formulas / Working with formulas / R1C1 reference style (must be unchecked)