Way to display result at the end of the sub only
 

Hi,

Is there a setting allowing to hide the result of the macro's functions
until the end of the sub?
I would like the macro not to update the workbook until the macro is
over.

Thanks in advance,

Kathe

Way to display result at the end of the sub only
 

Hi
Application.Screenupdating = False

as the first line of your sub will stop you seeing anything until the
macro finishes and cuts out all that screen flicker. Is that what you
mean?
(Note: no need to set it to true again at the bottom as it happens
automatically)
regards
Paul

wrote:
Hi,

Is there a setting allowing to hide the result of the macro's functions
until the end of the sub?
I would like the macro not to update the workbook until the macro is
over.

Thanks in advance,

Kathe

Way to display result at the end of the sub only
 

This is exactly what I was looking for!
Thanks Paul!!