Re: Length limitation of cell formulas

Hi Paul,

As others have said the length limit for a formula applied with vba is max
1024, or can be a bit less.

However you may be able to work around this. Eg, if the formula contains
references to other ***(s) you can rename ***(s) to something very
short, build your formula string with short names, apply the formula, then
restore original long *** name(s).

I don't know the "real" max length of a formula, as a guess 32k. Even though
the formula could be considerably more than 1024, you cannot "read" more
than the first 1000+ characters.

Regards,
Peter T


"Paul O. Schenker" <paul.schenker@xxxxxxxxxx> wrote in message
news:42664539$1_3@xxxxxxxxxxxxxxxxxx
> Hi all,
>
> is there a length limitation for formulas?
>
> Thanks for any reply.
>
> Paul
>
>


.

Loading