software

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
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

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