Naming a range
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
|