What is the command to hide macro operations

[Martin C]

I used to know this, but have forgotten it and cannot find it through Google
for the Excel help.

I have written a macro for a spreadsheet, but it is rather slow in running.
I once used a command that effectively hid the operations taking place by
the macro from the screen. This significantly increased the speed at which
the macro ran.

Does any kind soul know which VBA command is required to turn off the
console refresh and then later turn it back on again.

TIA
Martin

 

[Pete_UK]

Put this at the beginning of your code:

Application.ScreenUpdating = False

and don't forget to include this:

Application.ScreenUpdating = True

to turn it back on again.

Hope this helps.

Pete

 

[Martin C]

Thanks for the rapid response.
I remember now and it works.
Thanks again.
Martin


Put this at the beginning of your code:

Application.ScreenUpdating = False

and don't forget to include this:

Application.ScreenUpdating = True

to turn it back on again.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Martin - glad to help.

Pete

Thanks for the rapid response.
I remember now and it works.
Thanks again.
Martin


Put this at the beginning of your code:

    Application.ScreenUpdating = False

and don't forget to include this:

    Application.ScreenUpdating = True

to turn it back on again.

Hope this helps.

Pete






- Show quoted text -