I have no idea why this is returning an error for the OP. I've tested on three different machines now - download his workbook (original data.xlsx), paste in my code, and it runs perfectly for me every time, in 2010 and 2013.

Anyone able to test for me, see if I'm missing something obvious?

http://www.excelforum.com/excel-prog...aste-loop.html