VBA - How to make formulas dynamic when inserting new rows?

Hello everyone,

I have a macro that insert new blank rows, then copy and paste some rows, based on a input userbox. Those last rows contain formulas but, once pasting them, they become incorrect (problem of references). I'd like to make the formulas dynamic in the macro code (via R1C1) or via Index function so that inserting news rows, results don't change. As you can see on the picture, some cells are refering to another sheet, some are in absolute / relative references, but at the end, only rows #19 and #20 contain formulas.

How can I adapt the code below?

Please Login or Register  to view this content.

Note that I've already posted this thread on Mr Excel and Ozgrid, but it seems I can't upload the links..

Thanks a lot !

Hi, thanks, but like I said above, I can't upload the links where I've also posted this thread (I don't have enough posts yet or whatever).