---

Hej

Er der nogen som kan sige mig hvorledes jeg slå skærmopdateringen fra
mens min vba kode køre ? (fx. screenupdate = False)

På forhånd tak

MJ

---

Hej Mike

Option Explicit

Sub test()

ActiveSheet.Range("A1").Select

Application.ScreenUpdating = False
Dim x As Long
For x = 2 To ActiveSheet.Rows.Count
Range("A" & x).Select
Next x
Application.ScreenUpdating = True
ActiveCell.Select
End Sub


--
Med venlig hilsen
Jørgen Bondesen

---

Takker...

On Sun, 29 May 2005 21:22:47 +0200, "Jørgen Bondesen"
<bondesen@cool.dk> wrote:

> Application.ScreenUpdating = False

---

Hej Mike.

Velbekomme og tak for tilbagemeldingen.

--
Med venlig hilsen
Jørgen Bondesen


--
I am using the free version of SPAMfighter for private users.
It has removed 940 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!