View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sige
 
Posts: n/a
Default Data Validation with Defined Name

Hi There,

I have a Defined Name:
Sige ={"a";"b";"c";""}


When trying to use this Name in my Data Validation, allowing List,
source: =Sige
I get the message: "The source currently evalutes to an error"....
A funtion as: Index(Sige;2;1) returns me b

Any reaon why the data validation cannot handle this name?

Brgds Sige
-XL97-