Hi all,

I've got a macro which searches one sheet and copies a particular value to a
new sheet. There's alot of information and therefore when the macro runs the
screen flicks.

Is it possible to show a blank sheet while the macro runs so that the user
doesn't see whats happening?

thanks in advance

mike

Hi Mike,

At the beginning of your macro put:

Application.ScreenUpdating=False

then at the end of the macro put:

Application.ScreenUpdating=True


Regards,

Z

"mike" wrote:

Hi all,

I've got a macro which searches one sheet and copies a particular value to a
new sheet. There's alot of information and therefore when the macro runs the
screen flicks.

Is it possible to show a blank sheet while the macro runs so that the user
doesn't see whats happening?

thanks in advance

mike