I am inserting a row by Rows(fndVal1.Row).Insert. Now i
have formulas like =SUM(J7:J51) in rows after the new row
i insert. Now saw i insert a row at 50th....row. nowmally
if u insert a row manualy in excel automatically the
formula changes from =SUM(J7:J51) to =SUM(J7:J52)..as a
new is inserted. But when i am doing so by coding the
formula in my sheet is not changing.is it practically
possible? if yes what do i need to do!

thanks a lot
monika