I think this is what you meant:
Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

I would be a lot nicer to answer questions for people who use their
name (first and last) in the newsgroups.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote
I'm wondering if there is a way I can add new rows and keep the same
formulas in the newly added rows, instead of having to write the
formulas back into the cells one by one.