If I'm understranding you correctly, and I think I am, then what you'l
want to do is put this at the beginning of your code:

Application.ScreenUpdating = False

And at the end:

Application.ScreenUpdating = True

That should increase the speed quite a bit. - Piku

--
Message posted from http://www.ExcelForum.com