I 'cheated' - rewrote the code to add the rows to a new spreadsheet every 500,000 rows; so hopefully things never get too large.