ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Backslash in Named Range (https://www.excelbanter.com/excel-discussion-misc-queries/130930-backslash-named-range.html)

Dorci

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.

Dave Peterson

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


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com