Hello Excellers,

I have a workbook with a couple of defined names in it. But those names
don't show up in the name box of the formula bar. However they are
visible (and traceable) via Insert | Name | Define.

How can I make 'm visible in the name box. There are no macro's in the
workbook.

wkr Bret

You're defined names are technically defined *formulas* and those types of
defined names don't show up in the name box. For example:

rng1: =$A$1:$A$100
rng2: =OFFSET($A$1,,,COUNTA($A:$A))

rng1 will show up in the name box but rng2 will not


--
Biff
Microsoft Excel MVP


"Bret Bernever" wrote in message
...
Hello Excellers,

I have a workbook with a couple of defined names in it. But those names
don't show up in the name box of the formula bar. However they are
visible (and traceable) via Insert | Name | Define.

How can I make 'm visible in the name box. There are no macro's in the
workbook.

wkr Bret

You're defined names

<slaps forehead

Well, at least I didn't use yore!

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
You're defined names are technically defined *formulas* and those types of
defined names don't show up in the name box. For example:

rng1: =$A$1:$A$100
rng2: =OFFSET($A$1,,,COUNTA($A:$A))

rng1 will show up in the name box but rng2 will not


--
Biff
Microsoft Excel MVP


"Bret Bernever" wrote in message
...
Hello Excellers,

I have a workbook with a couple of defined names in it. But those names
don't show up in the name box of the formula bar. However they are
visible (and traceable) via Insert | Name | Define.

How can I make 'm visible in the name box. There are no macro's in the
workbook.

wkr Bret

In article ,
says...
You're defined names

<slaps forehead

Well, at least I didn't use yore!


:o))

Oké i understand why they won't show up in the Namebox. Thanks for the
hint Biff.

wkr
bret

You're welcome!

--
Biff
Microsoft Excel MVP


"Bret Bernever" wrote in message
...
In article ,
says...
You're defined names

<slaps forehead

Well, at least I didn't use yore!


:o))

Oké i understand why they won't show up in the Namebox. Thanks for the
hint Biff.

wkr
bret