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.