Speed up Add Rows VBA

[Chewyhairball]

Hi

I have this bit of code that adds a specified number of rows to table 1 depending on the value in A15.

It works fine but is a bit slow when adding a large number of rows. It is triggered from a button on the sheet.

I was wondering if there is a more efficient way of writing this to make it faster?

thanks

Rory

 

[Peter_SSs]

OK, no problem.