A way to not refresh data on screen?

[Kenji]

When I run the macro, the Excel sheet does a bunch of activities.

Is there a way to disable refreshing the screen.. so the user doesn't have
to see all the data being written in as it's done?

Kenji

 

[Peo Sjoblom]

Sub Macro()
Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True
End Sub

 

[A.W.J. Ales]

Kenji,

Sub test()
Application.Screenupdating = False

your macro contents

Application.Screenupdating = True
End Sub

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Kenji]

Thanks AWJ Ales and lexiinlace, it worked beautifully and made things 10x
faster!

Kenji