Many thanks Sébastien!
"sebastienm" wrote:
Excel has 2 modes for referencing A1 and R1C1. In A1-mode, row are numbered
and columns are A, B, C,... . In R1C1, R corresponds to Rows and C correspond
to Columns and both rows and columns are numbered.
To switch to one mode to another, go to menu Tools Options, tab General,
setting: "R1C1 reference style".
--
Regards,
Sébastien
"eel77" wrote:
Normally when referencing cells on another worksheet, the formula bar will
display something like so,
=Sheet2!B15
Under what circumstance would the formula be displayed like the following?
=Sheet2!R[-226]C
And how do I change this back to the "normal" formula format?
Many thanks!
|