But c doesn't look like a 'cell' reference, otherwise any letter would fail.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tom Ogilvy" wrote in message
...
You can't use any name that looks like a cell reference.


--
Regards,
Tom Ogilvy



"Bob Phillips" wrote in message
...
Which would suggest that c refers to the column would it not? In the
same
way you cannot use r, must be something to do with R1C1.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Charlie" wrote in message
...
You're right, I didn't know that. When I select a cell or range on a
worksheet, then ckick in the name reference box and type in "c" Excel
selects
the entire column of the active cell, rather than adds a named range
"c".
Using the Insert-Name-Define menu option gives me that same error
message
you got.

I guess you'll just have to use more descriptive names.

"Gary''s Student" wrote:

I am trying to assign Named Ranges as follows:

Sub Macro2()
Range("A1").Select
ActiveWorkbook.Names.Add Name:="a", RefersToR1C1:="=Sheet2!R1C1"
Range("B1").Select
ActiveWorkbook.Names.Add Name:="b", RefersToR1C1:="=Sheet2!R1C2"
Range("C1").Select
ActiveWorkbook.Names.Add Name:="c", RefersToR1C1:="=Sheet2!R1C3"
End Sub

The last line of code raises a 1004 That name is not valid.


Why?
--
Gary''s Student

Sure it does, you said it yourself. It does in R1C1. Names of Names don't
change with your choice of cell addressing.

C means current column. R means current row.


--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...
But c doesn't look like a 'cell' reference, otherwise any letter would
fail.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tom Ogilvy" wrote in message
...
You can't use any name that looks like a cell reference.


--
Regards,
Tom Ogilvy



"Bob Phillips" wrote in message
...
Which would suggest that c refers to the column would it not? In the
same
way you cannot use r, must be something to do with R1C1.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Charlie" wrote in message
...
You're right, I didn't know that. When I select a cell or range on
a
worksheet, then ckick in the name reference box and type in "c"
Excel
selects
the entire column of the active cell, rather than adds a named range
"c".
Using the Insert-Name-Define menu option gives me that same error
message
you got.

I guess you'll just have to use more descriptive names.

"Gary''s Student" wrote:

I am trying to assign Named Ranges as follows:

Sub Macro2()
Range("A1").Select
ActiveWorkbook.Names.Add Name:="a",
RefersToR1C1:="=Sheet2!R1C1"
Range("B1").Select
ActiveWorkbook.Names.Add Name:="b",
RefersToR1C1:="=Sheet2!R1C2"
Range("C1").Select
ActiveWorkbook.Names.Add Name:="c",
RefersToR1C1:="=Sheet2!R1C3"
End Sub

The last line of code raises a 1004 That name is not valid.


Why?
--
Gary''s Student