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.

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

<[email protected]> 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.
>