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

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

On Feb 8, 9:13*am, "Martin C" <mart...@invalid.com> wrote:
> 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

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


"Pete_UK" <(E-Mail Removed)> wrote in message
news:c1828612-32fc-47e0-998d-(E-Mail Removed)...
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

On Feb 8, 9:13 am, "Martin C" <mart...@invalid.com> wrote:
> 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

You're welcome, Martin - glad to help.

Pete

On Feb 8, 9:55*am, "Martin C" <mart...@invalid.com> wrote:
> Thanks for the rapid response.
> I remember now and it works.
> Thanks again.
> Martin
>
> "Pete_UK" <pashu...@auditel.net> wrote in message
>
> news:c1828612-32fc-47e0-998d-(E-Mail Removed)...
> 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
>
> On Feb 8, 9:13 am, "Martin C" <mart...@invalid.com> wrote:
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -