software

Hi There,

I have a Defined Name:
Sige ={quot;aquot;;quot;bquot;;quot;cquot;;quot;quot;}When trying to use this Name in my Data Validation, allowing List,
source: =Sige
I get the message: quot;The source currently evalutes to an errorquot;....
A funtion as: Index(Sige;2;1) returns me b

Any reaon why the data validation cannot handle this name?

Brgds Sige
-XL97-Sige,

Try naming a four cell range quot;Sigequot; and fill it in with your values. That will definitely work.

HTH,
Bernie
MS Excel MVPquot;Sigequot; gt; wrote in message oups.com...
gt; Hi There,
gt;
gt; I have a Defined Name:
gt; Sige ={quot;aquot;;quot;bquot;;quot;cquot;;quot;quot;}
gt;
gt;
gt; When trying to use this Name in my Data Validation, allowing List,
gt; source: =Sige
gt; I get the message: quot;The source currently evalutes to an errorquot;....
gt; A funtion as: Index(Sige;2;1) returns me b
gt;
gt; Any reaon why the data validation cannot handle this name?
gt;
gt; Brgds Sige
gt; -XL97-
gt;
Hi Sige

If you are trying to do data validation and only wanting an in put of
a,b,c or d then in the Refers to box just use
a,b,c,d
without any = sign in front.
Alternatively, in a set of cells A1:A4 enter a,b,c,d and call it Sige,
then use =Sige in the refers to box.
Note:
the first solution will only allow the lower case entries you typed in.
the second solution will allow upper or lowercase a,b,c,d

--
Regards

Roger Govierquot;Sigequot; gt; wrote in message oups.com...
gt; Hi There,
gt;
gt; I have a Defined Name:
gt; Sige ={quot;aquot;;quot;bquot;;quot;cquot;;quot;quot;}
gt;
gt;
gt; When trying to use this Name in my Data Validation, allowing List,
gt; source: =Sige
gt; I get the message: quot;The source currently evalutes to an errorquot;....
gt; A funtion as: Index(Sige;2;1) returns me b
gt;
gt; Any reaon why the data validation cannot handle this name?
gt;
gt; Brgds Sige
gt; -XL97-
gt;
Hi Bernie, Roger,

I am familiar with your proposals ... I was/ am just surprised that
Data Validation can handle lists where names are : cell-ranges,
formulas,... but no ''constant'' Names!

Bizar.
Thanks, Sige