No, it is because they are dynamic, they could refer to different ranges at
different times, that they don't show.

You can do this though

EditGoto (or Ctrl-G) and type the range name in the box and OK.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"hello" wrote in message
...
Hi

I have made several ranges on a spreadsheet, using "Insert", "Name",
"Define. They use the offset function, as below

=OFFSET(calc!$B$26,1,0,COUNTA(calc!$K:$K)+12,10)

if I hit Control-G, or look in the name box at the upper left, the names
of
many of these ranges do not show up. I cannot refer to, or highlight, the
ranges whose names do not show up.

The ranges are often created by simply modifying existing ranges, for
example, by changing the column. I wonder if this could be the problem.

Any help would be much appreciated.

Thank you