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],"N o","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
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)