| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backslash in Named Range
I inherited a workbook with several named ranges defined. Some of the names
are a backslash and one letter. Is there any significance to those? Is the backslash simply used to sort the names to the top of the list? I also notice that these names do not show up in the Name Box list with the others. Everything I've read simply says backslashes are allowed in range names, but nothing indicates when or why I'd use them. Your insight is appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Backslash in Named Range
IIRC, Lotus 123 macros were named that way. And _I think_ that they were run
with alt-letter in Lotus (ctrl-letter in early versions of excel???). Dorci wrote: I inherited a workbook with several named ranges defined. Some of the names are a backslash and one letter. Is there any significance to those? Is the backslash simply used to sort the names to the top of the list? I also notice that these names do not show up in the Name Box list with the others. Everything I've read simply says backslashes are allowed in range names, but nothing indicates when or why I'd use them. Your insight is appreciated. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| Paste a named range to another range in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
