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 wrote:

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.