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

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

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