Supress display of multiple steps in Macro

I'm a Macro NOVICE. i've recorded a macro which clears out cells, then
copies a portion from another screen, and then does some more
manipulations.

I'm sure there is a command to supress the everchanging display as the
macro executes, but I don't know how to find it. I have no manuals,
and I have no help files installed on my pc.

Hi MicroMain,

Try:

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True


However, the best way of avoiding the screen noise is to rewrite your code
to remove selections, which are rarely necessary and are usually
inefficient.


---
Regards,
Norman



"MicroMain" <rwhummer@gmail.com> wrote in message
news:1137556701.868244.95240@z14g2000cwz.googlegroups.com...
> I'm a Macro NOVICE. i've recorded a macro which clears out cells, then
> copies a portion from another screen, and then does some more
> manipulations.
>
> I'm sure there is a command to supress the everchanging display as the
> macro executes, but I don't know how to find it. I have no manuals,
> and I have no help files installed on my pc.
>

Worked Perfectly.

Thanks