Limit of Formula entered as a string manually or with VBA is 1024, though
could be a bit less.

The formula could get much longer than 1024 if, say, it contains renamed
longer sheetnames or linked file names. It will still work fine until you
come to reedit. A truncated and probably erroneous formula will get entered.

If that situation arises close the file without saving. Reopen, shorten
names, edit the formula, then rename the longer names if required.

Regards,
Peter T

"xcelion" wrote in
message ...

Hi All,

Iam writting a formula using Cells.Formula property.The formula string
has almost 800 characters.But i am not finding any probelm and it's
working fine in both excel 2000 and 2003.But i came to know from the
various web sources that the limit for fomula witten using VBA is 255
characters and the limit when the user types is 1024.But i have no
problem with 800 characters and it's working fine

So any one can please provide an answer for this ?

IS there any limit for the no of characters in formula written using
VBA or is is same as the limit when the user types the formula

Thanks in advance
Xcelion


--
xcelion
------------------------------------------------------------------------
xcelion's Profile:
http://www.excelforum.com/member.php...o&userid=16287
View this thread: http://www.excelforum.com/showthread...hreadid=392071