Range Name C

S

SanctifiedRock

I am using Data/Validation/List to display a list based on what i
entered in another cell. using the formula: INDIRECT({Cel
Reference}). My problem is one of my needed Named Ranges should be "C
but whenever I try to use it I get an error message.

Any Ideas how to fix this
 
B

Bob Phillips

Excel probably is getting confused with cell references. Use a different
name, differentiating form cell addresses.
--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"SanctifiedRock"
 
A

Ardus Petus

"C" and "R" are not valid names because they would get confused with L1C1
notation

HTH
 
B

Bob Phillips

R1C1 in English <g>

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top