Deleting excess rows
 

Hi,
I have a macro that works its way down a list of groups of data and inserts
a row after each of the groups. The problem I have is after the macro has
done its job, I have ended up with x amount of extra rows below where all the
data ends. Under normal circumstances it wouldnt pose a problem, but because
the data has loads of formulas attached to it, the macro takes longer each
time it is run. (Because it also mends the formulas)
Is there a way of deleting the extra rows that have been generated (code)?
Or - a code that hunts out the last bit of data at the bottom of a column
say, adds just 10 rows (that are needed) of blank rows, and then deletes the
rest down to a certain point?
Any help greatly appreciated
Regards
John