Re: Maximum length of Name reference values

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: William (willwest22_at_yahoo.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 23:43:41 +0100

Hi Rob

I think its 255 characters. 

-- 
XL2002
Regards
William
willwest22@yahoo.com
"robjs >" <<robjs.140521@excelforum-nospam.com> wrote in message
news:robjs.140521@excelforum-nospam.com...
| Does anyone know the maximum length of the 'reference' value associated
| with an Excel named item?  In other words, on the 'Insert->Name->Define
| dialog, if I set the "Name in workbook" field to be 'LITERAL', what's
| the maximum number of characters that the 'Refers To:' field can
| contain?  I'm sure it's a fixed limit - I doubt I can set the variable
| 'FREEDOM' to reference the text of the Declaration of Independence',
| but I can't find any documentation on either the max length, or any
| super-secret tips or tricks (pronounced 'registry entries' for
| extending it
|
| As always, thanks in advance,
|
| - Rob
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|

Relevant Pages

  • Re: good algorithms come with practice and reading good code/books?
    ... All I really use that book for is a reference to the c library functions. ... if given an input stream's file pointer, whereas in fact the behaviour is ... the source string is longer than or equal to count characters. ... thus ensuring that no array boundary overflow occurs. ...
    (comp.lang.c)
  • Re: Right justifying (arbitrary) alphanumeric input
    ... I have since learned that expressions are allowed in reference ... > modificaion, once I separate the operators from the operands. ... without a space - those 'semi-words' get stored with differing lengths ... keeping a count of total characters found ...
    (comp.lang.cobol)
  • [AustrE or NeoZE?] peculiar pronoun usage
    ... Shirley Hazzard in her novel /The Great Fire/ has some of her characters use the pronoun "she" in a peculiar way. ... For instance, this, in reference to a letter: ... a father has been promising his wife and daughter that they would make a trip to Britain, but has repeatedly broken his promise over the years. ...
    (alt.usage.english)
  • Re: PIC P put to real use
    ... I think this is a little more obvious than the reference ... it is a programming language. ... characters being replaced as well as the replacement text! ... I actually like that better than the reference modification. ...
    (comp.lang.cobol)
  • Re: Using Form Query to Load Multiple Tables
    ... The maximum length of an SQL statement using RunSQL is 255 characters. ... FROM tblEmployee AS e; ... an entry, in each of the linked tables, for the donor and reference ...
    (microsoft.public.access.forms)