See Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html#Name

Man Utd wrote:

In addition, how do I refer this cell range from another worksheet ?

"Man Utd" wrote in message
...
Dave,

As the formula removes C1 from the count, why C1 must has something ?
And what is the '9' does in the formula ?

As I think this formula can replace the name of the cell range used in the
Dta|Validation for a dropdownbox. My problem is I need another dropdownbox
as detail to this first dropdownbox.

If you add the entries in column C and don't leave empty cells, it
should
work
ok.

You can test it by adding/deleting entries from column C.

Then Edit|Goto|
type in the name you used and see what gets selected.

Although I'd use a slightly different formula:

=OFFSET($C$2,0,0,COUNTA($C:$C)-1,9)

And make sure C1 has something in it. (The -1 removes C1 from the count
of
cells used in column C.)



--

Dave Peterson