Copying Formulas When Automatically Inserting a Row

[tsturtz]

I am having a problem copying formulas down a row when a new row is inserted automatically. I have attached the workbook in question.

Any help.

Thanks,
Tony

[jeffreybrown]

Take a look at this link and see if it can be of some help...

http://dmcritchie.mvps.org/excel/insrtrow.htm#insrtrow

[Steffen Thomsen]

Hi,

The error in your code is with the range copied.

Try it now

[tsturtz]

Works great, thanks.