Hi Dangleor

Thanks for your input but the code you are suggesting are only inserting rows and does not copy forumuals.
Please refer to my original code, the macro is inserting and copying formulas only. This it does to both my sheets.
The macro is absolutely fine but i need a code to speed it up.
Thanks