Create New row in a table and copy/update formulas VBA

Originally Posted by royUK

Why does your profile show Excel 2003, but you add a 2007/2010 workbook?

Because it was hanging the page when I tried. Now it is OK

Thank you for your help Roy. I've used the code but it seems to add two rows at the time. One empty (row '11') and one correct below. Therefore formulas are not working as they are related to the data in the row above.

Also in C11 suddenly I get this formula

=IF(E11>0, C10+E11, 0)

and I don't know where it is from. At the same time other cells in row '11' have no formula copied over.

Could you please point me to where I get it wrong? Thanks

Tom