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

[Guest]

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.

 

[Guest]

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

 

[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.