screen flicking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top