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