I have a sheet with some 2,000 formatted lines and need to insert
another blank but formatted line together with all the formulae. I
currently copy the first blank line and then insert this into the sheet
before the last line of the table, shifting all following lines down.
This is the only way I can think of that will allow me to also keep the
number of the last row (which obviously changes) valid in various other
formulae.

This works OK but is TERRIBLY slow when doing it a couple of hundred
times. Any tips on how to speed up the process?

TIA, Dave