Adding 'n' number of rows with pasted formulas through VBA button

Hi,

I am working on a tool for analysis and created a VBA code for Adding 'n' rows in the sheet with provision to copy paste formula on all added rows from the last row of the original table. This takes a lot of time and puts the application into processing for a long period. Is there a way to optimize the below code for faster result: -

Please Login or Register  to view this content.

Don't loop. For example

Please Login or Register  to view this content.