MikeC, thanks for your help. That's a very interesting document. But I still have a problem. I have used Bob Bridges suggestion and added multiple rows using EntireRow.Insert; I have also tried to add a single row with Selection.ListObject.ListRows.Add (intCurRow - intHeader). In both of these instances, my code simply stops running after completing this line. Therefore I cannot put it in a For... Next... or Do Until... loop or carry out any further instructions.

I have found that even if I add table rows manually, it is not copying the formulae down, possibly because the formulae offer suggested values which are frequently overwritten. I therefore need to add my rows, and continue by entering the formulae into the appropriate columns of the new rows.

Any idea why my code stops as soon as I insert a row?