I'm having trouble understanding why a macro I recorded reads the way it does (I'm using Excel 2003)
If I am on SHEET1 in cell A1, and I record a formula "=SHEET2!R47" the macro displays as 
Range ("A1").Select
ActiveCell.FormulaR1C1!R[46]C[17]
If I am on SHEET1 in cell D6, and I record a formula "=SHEET2!R47" the macro displays as 
Range ("D6").Select
ActiveCell.FormulaR1C1!R[41]C[14]
I was expecting the R1C1 reference to Cell R47, on SHEET2, to be more like:
R[47] (because it's the 47th Row) and C[18], because it's the 18th Column
This is making it difficult for me to trouble shoot error. I believe it appears this way because the macro has "ActiveCell" and these are the coordinates relative to Range("XX").Select on SHEET1, albeit a different sheet.
Question: Is there something else I can do with the macro so I don't have to translate from the Range("XX").Select ?