When a makro is running, all the activities show on the screen. I know tehre
is a posibility to supress this, which has also the effect, that the macor
runs quickier.

Hi Esgu,

1) Use the ScreenUpdating property:

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True

2) (Which should be 1)!), avoid selections.
Selections are rarely necessary and tend to make your code less
efficient and harder to maintain. Additionally, they have the unfortunate
side effect you have observed.

---
Regards,
Norman



"esgu" wrote in message
...
When a makro is running, all the activities show on the screen. I know
tehre
is a posibility to supress this, which has also the effect, that the macor
runs quickier.