Only Copy Formula from the Row Above

[HangMan]

I am using the following code to insert and delete rows on a protected worksheet when there are locked columns. I want to be able to copy down any formulas from the row above when inserting new rows, but literally only formula not the content of the entire row. On the attached sample when inserting one or multiple rows, I would want to insert blank rows whilst copying the formula in columns N and AA down so the user can make new entries and the rows still sum. Is this possible? This would relate to any and all formula.

Using

Please Login or Register  to view this content.

copies the entire row.

This code on ThisWorkbook

Please Login or Register  to view this content.

And this code in a module

Please Login or Register  to view this content.

Many thanks

[jaslake]

Hi Hangman

Add the two lines of Code to the InsertRows procedure...

Please Login or Register  to view this content.

[HangMan]

Thanks jaslake, that works perfectly... so it's a case of having to 'manually' specify every column that contains the formula to be copied down as per your two additional lines?

Many thanks

[jaslake]

Hi Hangman

There are probably other ways...this is clean and simple...

specify every column that contains the formula to be copied down

You're welcome...glad I could help. Thanks for the Rep.