I just used a minor variation of Leith's code on 10,000 rows, and it worked perfectly. Post a workbook where it doesn't work.