Hi Klon,

Well - you haven't posted a sample book so I used my utility forum book, what I did was highlight six rows from column c to column o - then I played your macro and it ran real slick!

If you'll post your sample book, I'll be better able to advise you