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