Not allowed to define "C" as name

[abrogard]

I happily named some cells with one letter names: L, D, O, P … like that.

Because I like one letter variable names for ease of use when writing out formulas.

The system jibbed at ‘C’ because of something about it being a cell reference. I was in column C at the time.
So I played around a bit to see if that was the reason but it didn’t seem to be.
It seems of all the alphabet letters it didn’t like ‘C’. Why?

[anon73440385]

And what got the title of the question to do with the details of the question? Please adapt accordingly.

[LeroyG]

The dialog message is: “Invalid name. Reference to a cell, or a range of cells not allowed.”

[mikekaganski]

Calc: Named ranges-Hyperlinks in one sheet-C and R not working

I produced an alphabetised list similar to a contents list at the back of a book and added a hyperlinked alphabet as a heading linked to each of the section headings for easy navigation. I did this using named ranges and linking the quick find letter, with the corresponding section heading letter and named range, using the single sheet option. This was no problem including having a return to top hyperlink for 24 from the 26 letters. I cannot get C and R to work. I can produce the hyperlinked…

[erAck]

C is the column reference notation if the Excel R1C1 formula syntax is activated (Tools → Options → Calc → Formula) hence can not be used as a range name; same for R the row reference notation. E.g. =R[-1]C means same column one row up, which in the Calc A1 formula syntax is =A1 if entered in cell A2.