No names visible in name box of formula bar
 

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

No names visible in name box of formula bar
 

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

No names visible in name box of formula bar
 

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

No names visible in name box of formula bar
 

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

No names visible in name box of formula bar
 

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