Ask Your Question

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

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

abrogard gravatar image

updated 2020-08-04 01:29:54 +0200

LeroyG gravatar image

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 flag offensive 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.

Opaque gravatar imageOpaque ( 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."

LeroyG gravatar imageLeroyG ( 2020-08-04 01:28:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-08-04 02:28:22 +0200

erAck gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 52 times

Last updated: Aug 04