I need to create several named arrays of sequential numbers in excel

The microsoft artical http://support.microsoft.com/kb/75834 "Returning
an Array of Sequential Numbers in Excel" and a few others on the web
have methods to do this but require a range of cell be established. I
could do that and then refer a name to the range but I would rather
have a stand alone named range with the array.

For example the reference would be in a name would be like:
={1,2,3,4,5,6,7,8,9}

Is ther a way to generate this without having to type out the numbers?

Thanks Don, after I though about it, your right. Whats an extra
worksheet to reference the ranges cost me...

On Sep 26, 9:38*pm, Ron Rosenfeld <r...@nospam.net> wrote:
> On Mon, 26 Sep 2011 13:17:52 -0700 (PDT), Robert Hatcher <rhatcher...@gmail.com> wrote:
> >I need to create several named arrays of sequential numbers in excel
>
> >The microsoft articalhttp://support.microsoft.com/kb/75834"Returning
> >an Array of Sequential Numbers in Excel" and a few others on the web
> >have methods to do this but require a range of cell be established. I
> >could do that and then refer a name to the range but I would rather
> >have a stand alone named range with the array.
>
> >For example the reference would be in a name would be like:
> >={1,2,3,4,5,6,7,8,9}
>
> >Is ther a way to generate this without having to type out the numbers?
>
> I'm not sure exactly what you mean when you write "require a range of cell be established", or why that should be an issue.
>
> Various methods:
>
> =row(indirect("1:100"))
>
> =row($1:$100)
>
> =ROW(INDEX($1:$65536,1,1):INDEX($1:$65536,100,1))