Mental block

How do I define an array constant as a name?
I tried to insert a name as follows
Name: 2006!AgeRange
Refers to: ={<16,17-18,19-49,>49}
and it advised that the syntax was incorrect but was otherwise unhelpful.
I tried substituting ";" for "," as the element separators but that didn't
help either.
Thanks

--
Return email address is not as DEEP as it appears

Try this:

={"<16","17-18","19-49",">49"}

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jack Sheet" wrote:

> How do I define an array constant as a name?
> I tried to insert a name as follows
> Name: 2006!AgeRange
> Refers to: ={<16,17-18,19-49,>49}
> and it advised that the syntax was incorrect but was otherwise unhelpful.
> I tried substituting ";" for "," as the element separators but that didn't
> help either.
> Thanks
>
> --
> Return email address is not as DEEP as it appears
>
>
>

These values are text and not numbers so you need to use either

={"<16","17-18","19-49",">49"}

or

={"<16";"17-18";"19-49";">49"}

Regards,

Peo Sjoblom

"Jack Sheet" <[email protected]> wrote in message
news:%[email protected]...
> How do I define an array constant as a name?
> I tried to insert a name as follows
> Name: 2006!AgeRange
> Refers to: ={<16,17-18,19-49,>49}
> and it advised that the syntax was incorrect but was otherwise unhelpful.
> I tried substituting ";" for "," as the element separators but that didn't
> help either.
> Thanks
>
> --
> Return email address is not as DEEP as it appears
>

Thanks Peo, And Ron.
Your solotion worked, but for some reason it did not help me in the end. I
wanted to refer to the named array constant as a source for "pick from list"
in data validation, but it seems not to like it unless you dedicate cells to
the range.

"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:%[email protected]...
> These values are text and not numbers so you need to use either
>
> ={"<16","17-18","19-49",">49"}
>
> or
>
> ={"<16";"17-18";"19-49";">49"}
>
> Regards,
>
> Peo Sjoblom
>
> "Jack Sheet" <[email protected]> wrote in message
> news:%[email protected]...
>> How do I define an array constant as a name?
>> I tried to insert a name as follows
>> Name: 2006!AgeRange
>> Refers to: ={<16,17-18,19-49,>49}
>> and it advised that the syntax was incorrect but was otherwise unhelpful.
>> I tried substituting ";" for "," as the element separators but that
>> didn't help either.
>> Thanks
>>
>> --
>> Return email address is not as DEEP as it appears
>>
>
>