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

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

What happens if you type the name in the name box? Using your example, typing
the name displayed the range.

"hello" wrote:

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

Thank you. This correctly highlighed the range, but it presupposes that I can
remember the names in the worksheet. Sometimes there are too many named
ranges to remember. Is there a way to show these names automatically? I am
not sure, but I suspect that this is causing some problems I am having
linking to the ranges. I somehow doubt that I inserted the range properly in
the first place. I used "insert" "name" "define" and typed the formula in my
first post.

"Toppers" wrote:

What happens if you type the name in the name box? Using your example, typing
the name displayed the range.

"hello" wrote:

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