How can I see defined name range?
 

There are some formula there using defined name. I want to see which range it
is. But when I go to Insert--Name---Define is grey and I can't see its range.
Please advise.

How can I see defined name range?
 

I found the reason because it is protected.

"smart.daisy" wrote:

There are some formula there using defined name. I want to see which range it
is. But when I go to Insert--Name---Define is grey and I can't see its range.
Please advise.

How can I see defined name range?
 

F5 RangeName will let you highlight a named range, even on a Protected sheet.

Vaya con Dios,
Chuck, CABGx3



"smart.daisy" wrote:

I found the reason because it is protected.

"smart.daisy" wrote:

There are some formula there using defined name. I want to see which range it
is. But when I go to Insert--Name---Define is grey and I can't see its range.
Please advise.