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