Excel will not include all of my non-adj ranges in a named range??

[Renlimanit]

Does anyone know why excel 2002 will not include all of my non-adjacent
ranges in a named range? It includes 10 of my ranges and then just refuses
to include the last two ranges I highlight. Any ideas for a workaround are
welcome.
Thanks in advance.

[Dave Peterson]

How are you creating it?

If you're using the namebox and already used that name, excel thinks you want to
select that existing range.

Just Insert|name|define and define the name there--
or
delete the name and then use the namebox.



Renlimanit wrote:
>
> Does anyone know why excel 2002 will not include all of my non-adjacent
> ranges in a named range? It includes 10 of my ranges and then just refuses
> to include the last two ranges I highlight. Any ideas for a workaround are
> welcome.
> Thanks in advance.

--

Dave Peterson

[Renlimanit]

I did it the way you described and the name was not repeated. Any other
suggestions?
Thanks again for your help.

"Dave Peterson" wrote:

> How are you creating it?
>
> If you're using the namebox and already used that name, excel thinks you want to
> select that existing range.
>
> Just Insert|name|define and define the name there--
> or
> delete the name and then use the namebox.
>
>
>
> Renlimanit wrote:
> >
> > Does anyone know why excel 2002 will not include all of my non-adjacent
> > ranges in a named range? It includes 10 of my ranges and then just refuses
> > to include the last two ranges I highlight. Any ideas for a workaround are
> > welcome.
> > Thanks in advance.
>
> --
>
> Dave Peterson
>

[Dave Peterson]

There is a limit on how long the string would be in the insert|name dialog.
Maybe you're approaching this length.

But I don't recall having any problem using the name box (if that name hasn't
been used before).

Or you could try this:
Select your ranges
hit alt-f8 (to get to the VBE
hit ctrl-g (to get to the immediate window)

type this and hit enter
selection.name = "myNameHere"

then back to excel to see if that worked.

Renlimanit wrote:
>
> I did it the way you described and the name was not repeated. Any other
> suggestions?
> Thanks again for your help.
>
> "Dave Peterson" wrote:
>
> > How are you creating it?
> >
> > If you're using the namebox and already used that name, excel thinks you want to
> > select that existing range.
> >
> > Just Insert|name|define and define the name there--
> > or
> > delete the name and then use the namebox.
> >
> >
> >
> > Renlimanit wrote:
> > >
> > > Does anyone know why excel 2002 will not include all of my non-adjacent
> > > ranges in a named range? It includes 10 of my ranges and then just refuses
> > > to include the last two ranges I highlight. Any ideas for a workaround are
> > > welcome.
> > > Thanks in advance.
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson