stop screen refresh
 

sub macro()

Application.ScreenUpdating = False

' your code here

Application.ScreenUpdating = True

end sub


This puts off screen updating till the macro is executed. But don'
forget to turn it on at the end

- Manges

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