Quote Originally Posted by mikehzz View Post
Mate there is nothing wrong with that code. I have run it to automatically insert 2000 rows in a sheet I just set up with no issues. I would suggest that there is a problem somewhere in your sheet. Does your sheet only have 340 rows or are there many more but hidden? The error type smacks of some sort of memory or data corruption. Cheers
Corrupted! Thanks for the clue

The formatting of the cells (single lines around each cell) was corrupted. I created a new sheet and when I tried to copy/paste special the formatting Excel crashed. So I recreated the formatting and the size of the file overall went from 1.4GB to 143KB.

And it works!

Thanks guys.