Naming a range of cells

[DebraJess]

I'm trying to name a range of cells to be used in creating a drop-down list. Each cell has a number ranging from 0 to 10. Each time I try to name the cells, excel eliminates the cell with the 0 in it. I need to be able to use the 0 in my list. Is there a way to make this happen? I will need to add these cells together in a different column.

Thank you!

 

[Scott Huish]

I'm not sure what you mean, I put the numbers 0 through 10 in G1:G11, and named this range allowed.

And then in Data Validation, under Allow, choose List
Under Source put =allowed

alternatively, you could just put under source:
0,1,2,3,4,5,6,7,8,9,10
and then you wouldn't need a range named or not.

 

[Datsmart]

How are you naming the cells? Using code or manually?
If code, please post it.

Are you naming each cell or a range of cells?

Under Tools | Options
On the "View" tab, is Zero values checked or unchecked?

 

[DebraJess]

Oh, dear. I think I just answered my own question. I seems that once you name a range of cells, that's it. Your stuck with that name and range. The only way to edit it is to delete the column and start from the beginning. What I didn't mention in my question (silly me ) was that I was trying to edit my range of cells to include the 0 digit. I didn't know you couldn't do that.

Everything is okey dokey now. Thank you for helping! :wink:

 

[Datsmart]

You can "over-write" named ranges using code. Like:

ActiveWorkbook.Names.Add Name:="MyRange", RefersTo:=Range("A1").CurrentRegion

Manually you have to delete the original range first.