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

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.

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

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

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