A way to not refresh data on screen?

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

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

--

Regards,

Peo Sjoblom

"Kenji" wrote in message
...
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

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" wrote in message
...
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

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

Kenji

"A.W.J. Ales" wrote in message
...
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" wrote in message
...
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