Application.ScreenUpdating = False
at the start, and just before the end
Application.ScreenUpdating = True

--
kassie

never stop learning




"stinson" wrote in message
...
Is there a way to have the spreadsheet screen refresh after the macor is
finished instead of during the macro run? Currently the changes to the
spreadsheet are reflected as the macro runs. I would like the user to see
just one refresh when the macro is complete.

Tom