Yes, there is a limit to the length of a formula - 1024 characters, so
depending on how your sum formula was formed this might have hit the
limit. There is also a limit of 30 arguments in a function, e.g. if you
have =SUM(a, b, c, d ... etc), you will only be allowed 30 of them.

Hope this helps.

Pete

Lakshman wrote:

HI

Thanks for the reply.I have one more query can any memory problem be a
cause of it?.I debugged the code and when it was throwing the error at
that time the cell it was pointing to was holding reference of around
sum of 130 cell values in a formula.May be it doesnt make sense,but
just wanted to check.

Regards

Lakshman

Pete_UK wrote:
Well, I'm sorry - I don't think anyone will be able to help you without
any further details.

Pete

Lakshman wrote:

Hi
Thanks for the reply,The Value of inttotalrow and intcol are
(2849,35) and the cell which it is referring is containning a
formala,My main query is when this is workig very well in Excel 97 why
it is not working in Excel 2003 ?

Yes I know it will be difficult without the code,but the thing is I am
not allowed to paste the code....Thats the reason.Sorry for that.

Regards

Lakshman