oh yes, hah. mine probably never moved cells, so you do need that select line in the for loop. I am glad you got it fixed. Unlike in your case, most of the time you do not need to use select lines. Your other code was pretty messy, it looked like excel created it from a macro builder, which is fine, but will run slower in the long run.