adding new rows and keeping the same formulas
 

Hi,

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.

adding new rows and keeping the same formulas
 

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.