David McRitchie shares some code:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Juan L wrote:

Friends:
Please, i need a code that asks for how many records the user wants to
insert below a row and then copy the formulas from the original one . Would
be great if it could use a text box or something,

sorry friends i don´t know programming but i trust in u.
Thanks for your great help.
Regards,

--

Dave Peterson