How to stop Excel from animating range selections?
 

Hello,

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

How can I switch off this behaviour?

Thanks and rgds,

Gerr

--
gstreme
-----------------------------------------------------------------------
gstremer's Profile: http://www.excelforum.com/member.php...fo&userid=3589
View this thread: http://www.excelforum.com/showthread.php?threadid=55685

How to stop Excel from animating range selections?
 

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

How to stop Excel from animating range selections?
 

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