How to stop Excel from animating range selections?

[gstremer]

Hello,

In my VBA programme I select a lot of different ranges. At present Excel shows these range selections on screen. This makes that the user gets to see Excel jumping from one sheet to another during the programme's execution.

How can I switch off this behaviour?

Thanks and rgds,

Gerry

[[email protected]]

Hi
Application.ScreenUpdating = False

You might also think about not doing the selections
e.g Range("A1").Select
Selection.Value = 3

can be shortened to
Range("A1").Value = 3

regards
Paul

gstremer wrote:
> Hello,
>
> In my VBA programme I select a lot of different ranges. At present
> Excel shows these range selections on screen. This makes that the user
> gets to see Excel jumping from one sheet to another during the
> programme's execution.
>
> How can I switch off this behaviour?
>
> Thanks and rgds,
>
> Gerry
>
>
> --
> gstremer
> ------------------------------------------------------------------------
> gstremer's Profile: http://www.excelforum.com/member.php...o&userid=35897
> View this thread: http://www.excelforum.com/showthread...hreadid=556850

[michael.beckinsale]

Paul,

Put this line at the beginning of your code:

Application.ScreenUpdating = False

change false to true to switch back on again

Regards

Michael Beckinsale