Run time error 1004 When running in 2003

[Lakshman]

Hi

I have a Excel template which is working fine in office 97 but when I
am trying to run it on Office 2003 it gives me a run time error 1004
"Application Defined or Object Defined Error " during completion of
process which means it runs for 30 minutes without error and it throws
me an error in the end.Could any one help me on whats happening?

 

[Debra Dalgleish]

If you describe what the macro is supposed to do, and where it gets
stuck, and include the code, someone may be able to help.

 

[Lakshman]

Hi
Thanks for the reply.To state the fact I am d not aware of what it is
actaully supposed to do,I am just copying the templates from off97
machine to off2003 machine and running it from off2003 machine to make
sure that its working fine.

Regards
Lakshman

 

[Debra Dalgleish]

If you can find out what it's supposed to do, or post the code here,
someone may be able to help. Without a few clues, it would be very
difficult to figure out what's wrong, or how to make it work.

 

[Lakshman]

Hi
Thanks for the reply.The overview of what I am doing is running the
template in off2003 (Which was running well in off 97 ) for which you
have to give one excel file filled with some data as the input and this
template start processing the data and provides summary based on the
input on the same input file creating another sheet.

The Point where It gives me error is in ac function

Var_total = cell(inttotalrow,intcol).Formula

When the cursor reaches this point it throws an error saying "Runtime
Error 1004 - Application error or Object Defined Error "

Hope this will help in identifying the cause.

Thanks & Regrads

Lakshman.

 

[Pete_UK]

Do you happen to know the values of inttotalrow and intcol when the
macro crashes? If they are outside the physical boundaries of the sheet
(65536 and 256) then this would give rise to a run-time error.

As Debra said, it is difficult to diagnose the problem without more
detail. Copy the macro here and someone might be able to help further.

Pete

 

[Lakshman]

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

 

[Pete_UK]

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

Pete

 

[Lakshman]

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]

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]

Hi

One quick update needed ,i tried to put On error resume next in the
function where it was giving error and it executed fine till the end?Is
it throwing some kind of clue.I compared the results also ,it looks
same thou i didnt check in detail.


Thanks & Regards

Lakshman