You can learn quickly by clicking cells instead of typing their addresses.
Or temporarily change to A1 style (ToolsOptionsGeneral tab, Uncheck R1C1 Reference style) and then change back (or not).
If the formula is in A1, then =H5 becomes =R[4]C[7]
$A$1 becomes R5C8

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"John Smith" wrote in message ...
| How do I refer to a particular cell when the spreadsheet is set to
| r1c1 style? The spreadsheet does not accept H5 or things like
| that. Thanks.