Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Query and expanding named ranges [email protected] Excel Discussion (Misc queries) 1 July 21st 06 08:35 PM
Importing Excel named ranges using MS Query KHanna Excel Discussion (Misc queries) 0 July 21st 06 04:49 AM
Named ranges: don't want absolute references sonicblue Excel Discussion (Misc queries) 0 November 22nd 05 02:05 PM
INDIRECT and Named Ranges referencing closed workbook gpie Excel Worksheet Functions 9 October 6th 05 11:24 PM
How to Link named ranges from multiple Workbooks into a single Wo. PMAP_HELP Excel Discussion (Misc queries) 1 December 14th 04 05:51 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"