screen refresh
Sub Whatever()
application.screenupdating = false
'Your code here
application.screenupdating = true
end sub
--
HTH...
Jim Thomlinson
"stinson" wrote:
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
|