adding new rows and keeping the same formulas

[email.hue]

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.

 

[David McRitchie]

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.