Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range naming | Excel Discussion (Misc queries) | |||
Naming a range during macro execution | Excel Discussion (Misc queries) | |||
=OFFSET(!$A$1,,,,) - global range naming | Excel Worksheet Functions | |||
Naming Sheets using a range in another worksheet | Excel Worksheet Functions | |||
Naming a range | Excel Discussion (Misc queries) |