Types of cell references?

[MikeB]

I'm (as usual) floundering in the Office 2007 Help files.

In the description of the Indirect function, the following appears:


A1 is a logical value that specifies what type of reference is
contained in the cell ref_text.

If a1 is TRUE or omitted, ref_text is interpreted as an A1-style
reference.

If a1 is FALSE, ref_text is interpreted as an R1C1-style reference.


So what exactly is a A1-style reference? I assume the R1C1-reference
is a row/column reference (such as B3)?

I swear, trying to search for things like this in the Help is a
complete waste of time.

 

[Gord Dibben]

You assume incorrectly.

A1 style is just that.............column is letter A, row is number 1

B5 is column B and row 5

R1C1 style is Row/Column.............if you set the option to "R1C1
reference style" you will see numbers for column headers and row headers.

R1C1 is Row1 and Column1

Equivalent to B5 would be R5C2


Gord Dibben MS Excel MVP

 

[MikeB]

Well, thank you muchly. Ans also for the help on the other question.
Much appreciated.

M