One more...

This worked ok for me in xl2003:

Option Explicit
Sub testm()
Dim myFormula As String
Dim iCtr As Long

myFormula = "=A1"
For iCtr = 2 To 200
myFormula = myFormula & "+A" & iCtr
Next iCtr

MsgBox Len(myFormula)

Range("b1").Formula = myFormula
End Sub

Any chance you're looking at .formulaArray?

xcelion wrote:

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

--

Dave Peterson