R1C1 Reference in Macro, Don't Understand

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

Please Login or Register  to view this content.

If I am on SHEET1 in cell D6, and I record a formula "=SHEET2!R47" the macro displays as

Please Login or Register  to view this content.

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 ?

The R1C1 formula is relative to the cell in which it is inserted. If you want an absolute reference, then when you enter it in Excel, surround the column and row components with $ so you enter:

=$R$47

And in the macro code this will be recorded as:

Please Login or Register  to view this content.

Firefly,
Thanks for the information!