# Not allowed to define "C" as name [closed]

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?

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by erAck close date 2020-08-04 19:04:20.837726

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

( 2020-01-24 13:17:53 +0200 )edit

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

( 2020-08-04 01:28:23 +0200 )edit
1

Sort by » oldest newest most voted

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.

more

## Stats

Asked: 2020-01-24 05:20:01 +0200

Seen: 52 times

Last updated: Aug 04