I have defined a dynamic range using the offset and counta functions in the
define name box. The name works fine in my formulas, but does not appear in
the drop-down name box on the formula bar. Is there a way to get this name
to appear there? Thanks.

Dave

Nope.

But you could use Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp



DaveNadler wrote:

I have defined a dynamic range using the offset and counta functions in the
define name box. The name works fine in my formulas, but does not appear in
the drop-down name box on the formula bar. Is there a way to get this name
to appear there? Thanks.

Dave

--

Dave Peterson