Re: how does excel decide a suggested name to a range?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


jan karel pieterse has done extensive research on names.
(he would, else how could he wriote his excellent name_manager)

worth a read is:
http://www.jkp-ads.com/Articles/ExcelNames.htm






--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tushar Mehta wrote :

> That is XL's way of creating legitimate names. In addition to
> characters that are invalid in a name (such as / and space), certain
> names such as a one indistinguishable from a cell reference (B1 or
> D12, for example) are also invalid.
>
> I thought there was some documentation that indicated the rules for
> valid names. But a 10 minute search of help and msdn.microsoft.com
> proved futile. What you can do is develop your own rule for creating
> names. I use the following:
>
> Names I create programmatically start with _TM{add-in id}
> _TM to identify a name created by a program I wrote
> {add-in id} identifies which program
>
> If the name is being created from some user-specified source (file
> name for example), I remove all characters other than letters and
> numbers.
>
> If the name concatenates two tokens (chart name and series name for
> example), I remove all characters other than letters and numbers and
> then use underscore between the two tokens to get something like
> _TMAddInID_chart1_series1
>
> Does this guarantee that the user doesn't have the same name in the
> workbook? No. But, it reduces the likelihood.
.

Relevant Pages

  • Re: Naming convention for Login names?
    ... Normally, valid names should contain only letters and numbers, starting with ... "TestUser\ is not a valid name because it contains invalid characters". ... How would one know ahead of time whether the login contains invalid ...
    (microsoft.public.sqlserver.security)
  • Re: Is alpha Numeric
    ... characters, ... > How can I tell if a field on a form contains an Alpha ... I want to make sure the field contains both, numbers and letters. ...
    (microsoft.public.access.formscoding)
  • Re: Is alpha Numeric
    ... > ' invalid ... > characters, then add a third test: ... I want to make sure the field contains both, numbers and letters. ...
    (microsoft.public.access.formscoding)
  • Re: Iron Heroes: the good things
    ... I really like the idea of customizing human characters. ... >> Essentially, you earn tokens for doing certain things, mostly in combat ... >> Skill Groups, which essentially allow the character to spend 1 skill ... The greatest thing about it is the Fury tokens. ...
    (rec.games.frp.dnd)
  • Re: User Accounts
    ... Change the name of the account. ... hackers as a means of getting a foothold into your system. ... using all upper case or all lower case letters. ... It should contain at least eight characters. ...
    (microsoft.public.windowsxp.help_and_support)