Add New Row with formulaes

[bengaluru]

Hello friends

I have a "Add new Row" button that adds a new row at the top of the sheet. My code is

Please Login or Register  to view this content.

Although it adds a new row at the top, it does not add the formulaes in some of the cells - even the simple ones such as "=B16"

What do I have to do to get the formulaes as well in the new row ?

Thanks for your help.

[Leith Ross]

Hello bengaluru,


Here is the macro. After the new row is added, the row above and all the rows must be updated using the Fill Down method.

Please Login or Register  to view this content.

[bengaluru]

Excellent Leith Ross. Thank you so much for the quick solution. It works absolutely.

Have a great day.