screen flicking
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
|