ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Named Ranges - what characters are (or are not) allowed in the nam (https://www.excelbanter.com/excel-discussion-misc-queries/103156-re-named-ranges-what-characters-not-allowed-nam.html)

Niek Otten

Named Ranges - what characters are (or are not) allowed in the nam
 
Hi Barb,

From Excel Help:

What characters are allowed? The first character of a name must be a letter, an underscore character (_), or a backslash (\).
Remaining characters in the name can be letters, numbers, periods, and underscore characters.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Barb Reinhardt" wrote in message
...
| I'm trying to create named ranges programmatically and need to know what
| characters are and are not allowed in the names. So far, I assume that _ and
| text are included. I know that a lot of special characters are not
| (&,+,-,space, etc).
|
| Can someone assist?
|
| Thanks,
| Barb




All times are GMT +1. The time now is 02:17 AM.

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