Re: Length limitation of cell formulas

that just caused an error on the first message box. (xl2003). The formula
was truncated to 1023 characters. what is the significance of 5489. It
appears the limit is 1024 as stated in help. If you do a recalc, you will
see the truncated formula isn't functional (it isn't secretly working as it
appears you are trying to imply).

--
Regards,
Tom Ogilvy

"Peter T" <peter_t@discussions> wrote in message
news:eTlBEZbRFHA.3144@xxxxxxxxxxxxxxxxxxxxxxx
> typo:
>
> > ...length of 5489:
> should read
> length of 5849
>
> Peter T
>
>


.

Relevant Pages

  • Re: count occurences of font color
    ... Tom Ogilvy ... Debug.Print Timer - s ... ' using isnull and not using characters ... as the loop will exit on the first character. ...
    (microsoft.public.excel.programming)
  • Re: Select Method from Combo Box
    ... > assumes a combobox from the control toolbox toolbar. ... >>> of characters that match exactly one entry in the list. ... >>> Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: Excel cannot import Null characters (?)
    ... I formatted the cells in Excel as MS Ariel Unicode before ... Tom Ogilvy ... null characters - the second part/byte of the unicode two byte characters. ...
    (microsoft.public.excel.programming)
  • Re: Relatively new to macros
    ... I would see no role for autocomplete in the question asked. ... characters are redefined in autocomplete, ... into that event for this purpose? ... "Tom Ogilvy" wrote: ...
    (microsoft.public.excel.programming)
  • RE: sql statement with error #933
    ... OMG! ... What a monster. ... It would be all too easy to have a typo in that thing. ... It has about 5300 characters. ...
    (microsoft.public.access.queries)
Loading