If I'm understanding your question, put:

Application.ScreenUpdating = False

At the top of your code and:

Application.ScreenUpdating = True

at the end. - Piku

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