Problem naming a range

  • Thread starter Thread starter Don Guillett
  • Start date Start date
I am using Excel XP.

I am trying to name a range of cells.
I select the cells I want and then try to enter the name in the box.
It accepts the name but when I press enter the name disappears and does not
appear in the drop-down of the list of ranges.

What am I doing wrong?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Yes. I am.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
What name are you using? There are some restrictions, that you can find
in Excel' Help, under the heading 'About labels and names in formulas'

For example, the name must be one word, and start with a letter or
underscore.
 
What name are you using?

Does it conflict with anything else?
Does it look like an address? (A32)
Is it valid? (although I got errors when I typed something invalid)
 
Just realised what the problem is.

The worksheet is protected!!!

Stupid!!!

Sorry for that.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart with Named Range error 1
Keyboard shortcut to Name Box 10
Excel Limit to Named Ranges 1
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2
Oversensitive touchpad on modern laptops 0
Width of Active Cell Name drop down combo list 6
checkbox problem 22
Drop Down with dynamic named range offsheet source list 14

Back
Top